jeristotle
asked on
ASP Export into Excel with Multiple Worksheets
Please accept my apologies in advance for this additional posting and also for any help you can offer. I've searched around, found several examples of solutions, but I can't get any of them to work completely.
To be clear, I'm trying to export data through an ASP page, ideally .NET, to render in Excel 2000. My current station is a Windows 2000 station. I have an ASP Classic version that works, but it won't allow me to create multiple sheets.
This article will be a good starting point as far as the research I've done: https://www.experts-exchange.com/questions/20919538/ASP-Export-to-Excel-with-multiple-pages.html
I tried the version with <x:ExcelWorksheet> in combination with the table tags provided by Fritz the Blank, and it sets up/names multiple sheets for me, but the data appears on a single sheet only. (I've at least been able to duplicate Fritz's initial state and prove I'm able to at least create multiple sheets.)
I followed the complete XML example provided by sybe, but it wouldn't create multiple sheets, and the data all showed up on one sheet, all data in one cell per row.
If the sybe example is supposed to work as Fritz indicates, and I have every confidence it does, then the issue is somewhere else. Station configuration, maybe? Can anyone offer a suggestion as to how I should proceed?
Thank you again for taking the time to read this and also for any assistance you can provide.
To be clear, I'm trying to export data through an ASP page, ideally .NET, to render in Excel 2000. My current station is a Windows 2000 station. I have an ASP Classic version that works, but it won't allow me to create multiple sheets.
This article will be a good starting point as far as the research I've done: https://www.experts-exchange.com/questions/20919538/ASP-Export-to-Excel-with-multiple-pages.html
I tried the version with <x:ExcelWorksheet> in combination with the table tags provided by Fritz the Blank, and it sets up/names multiple sheets for me, but the data appears on a single sheet only. (I've at least been able to duplicate Fritz's initial state and prove I'm able to at least create multiple sheets.)
I followed the complete XML example provided by sybe, but it wouldn't create multiple sheets, and the data all showed up on one sheet, all data in one cell per row.
If the sybe example is supposed to work as Fritz indicates, and I have every confidence it does, then the issue is somewhere else. Station configuration, maybe? Can anyone offer a suggestion as to how I should proceed?
Thank you again for taking the time to read this and also for any assistance you can provide.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER