469,282 Members | 1,772 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Export to excel workbook

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
0 2236

Post your reply

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

Similar topics

1 post views Thread by Nathan Bloomfield | last post: by
8 posts views Thread by DC Gringo | last post: by
7 posts views Thread by Vanessa | last post: by
5 posts views Thread by Simon | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.