By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,387 Members | 1,751 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,387 IT Pros & Developers. It's quick & easy.

Export to excel workbook

P: 1
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.
Oct 2 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.