Too many columns for classic form,Switched layout to compact form

Thanks for the reply,
checked the mentioned link, while exporting instantly changed from classic to compact because more than lakh data.
 
Code : 

function exportClassicForm() {
let container = document.querySelector("#pivotContainer");
let initialWidth = container.getBoundingClientRect().width;
container.style.width = ((pivot.gridColumnCount() - 1) * 110 + pivot.getRows().length * 110) + "px";
pivot.setOptions({
grid: {
type: "classic"
}
});
pivot.refresh();
}

By using this code the compact change to classic but it again instanly change to campact automatically. If any other way to change compact to classic.
any possibility to enables a scroll bar for the frozen areas also.

Hi,
 
In the above code sample,  it changes the compact grid to a "classic" grid and export that data.
We implemented your code (what you attached in form of a link),
it exports the 1st line only to "classic" form,
after that rest of the lines doesn't changes (rest of the line are still in "compact" format)
Because we have 1lacs records,
while clicking "export", the grid change to classic and triggers export loader,
meanwhile, the grid automatically changes back to "compact" (without using exportcomplete function in the sample).

so we got an unexpected file.
 
The above sample code works fine and gives the expected output in https://jsfiddle.net/k1f8ymru/
 
but while implementing the above sample code in our project we are facing this problem.