Question:
When exporting data to Excel using the PrintToFile() function, they stay in a single cell of the file. How can I configure them to be exported respecting the columns and cells configured on the table displayed on the Browser?
Solution:
To do so, you must use the Chr(9) separator in the PrintToFile() command.
Example of script:
Reports.Report1.PrintToFile(“historic.xls”,1,Chr(9),1)
