473,326 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

ASP.NET produce output to excel (.xls) with multiple worksheets

dafodil
392 256MB
Hi I have a problem with exporting my produced datas to excel. I already tried using the xml.. where I create a html document and allow the user to download my excel file. The report created was basicaly simple which suits my website need. But I cannot produce multiple work sheets. I'm using Microsoft office 2000. Any ideas on how can I produce multiple worksheets using asp.net particularly on Microsoft Excel 2000?
Jun 3 '09 #1
2 3272
dorandoran
145 100+
So many good article came up when I did a search on google.

http://www.google.com/search?q=asp.n...x=&startPage=1
Jun 4 '09 #2
dafodil
392 256MB
@dorandoran
Actually, I already tried those codes.
After series of trying I ended up doing only one worksheet on Excel 2000. The problem with most of the samples is that it is for Excel 2003 and beyond. Excel 2000 does not fully support xml that's why it cannot create multiple work sheets via xml. There is one way to this if I try to install the excel on the server and use the Microsoft Excel com object. But that will not suit my application and will only cause my app to become slower.

My solution back to xml with only one worksheet.
Jun 8 '09 #3

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

Similar topics

0
by: Shawn | last post by:
I have the basics working as is described in KB199841. I currently have my ASP page loading into Excel by setting the ContentType of the page: <%response.ContentType="application/vnd.ms-excel"%> ...
5
by: Iris | last post by:
I have 8 text files (tab delimited) that I would like to import into an Excel workbook as 8 individual worksheets but I cannot find any example code on this subject. Can anyone help me please???? ...
3
by: lblanton | last post by:
I am trying to import an excel file with multiple worksheets into a single access table. The worksheets are formatted the same and with the same column headings but have varying rows. How do I import...
5
by: tenko | last post by:
anybody knows how to produce output restricted to just 2 decimal places? thanks :-)
0
by: Eric | last post by:
Hi all, First i appoligise for my bad english. For a friend i need to create a script that can read XLS documents. Well that's not the problem anymore... with the code (down here) i've already...
2
by: hal | last post by:
Hello all, I've been searching all day for an article or tutorial on how to get data from a SQL Server 2000 database and export the data to excel 2003 so that multiple worksheets are created,...
1
by: hdogg | last post by:
I embed this on top of my pages: header("Content-Type: application/vnd.ms-excel"); This makes it so my page downloads as Excel... However, I want more than one worksheet.
16
by: poolboi | last post by:
hi guys, i've got the code below that extract cell value from an excel sheet but any idea how i continue to output it to a text file? i'm not too sure how to do it, thanks use strict; use...
3
by: arjun007 | last post by:
i want to read multiple worksheets in a single program using php.i done it for one excel sheet by saving .csv file. but,iwant to read multiple worksheets.please help me.................
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.