Out put in Single Excel File

[zaska]

Hi all.

I have a Jscript which exports the data to a .Csv file....When i run the code for the second time the contents of the first .Csv were getting overwritten.

ExportFileName = "Report.csv"; 

{SB.Export( ExportFile );

Is it possible to export the data to separate Sheets in the same workbook.

Thank u

 

[Richard Schollar]

Hi

csv files are flat text files - they don't have multiple sheets eg like an Excel workbook would. You could perhaps append the data to the end of the existing file? I am afraid I know zip about jscript though so you would be best off asking on a Jscript forum if you get no other answers here.

 

[zaska]

Hi,

Thank you for the Reply.

I understood now...But how do i modify or append the data to Each sheet in a single excel file in the above code.

I tried modifying the .Csv Extension to .Xls but the result is same except that i didn't get comma separated values..

I want to modify the code to get the results in a single Excel file.( Sheet1, Sheet2 , Sheet3 etc.,)

Is it possible with .xls? and how do i append the d

Thank u