|
How to export data using ASP to excel workbook (with multiple worksheets)?
I created an excel workbook with 5 worksheets and each one has a name range.
Using asp I insert data to individual worksheet. The problem is that excel treat all numbers as string/text when I do:
rsExcel.Fields(0).Value = 5
When I open an excel file the value 5 is display as "5"
If I use application/vnd.ms-excel method I can get the value display correctly as number type but I cannot figure out how to create multiple worksheets with it.
Please help
Thank you.
| 
