ASP to Excel. Help with getting data into XML

busabus · busabus

I have an ASP application that uses an Access back end, and basically
I wanted to get the data into an Excel spreadsheet for reporting
purposes. I decided to go down the XML route as that gives me good
formatting options, and allows for multiple workbook pages, and all
the users have Excel 2002. However I'm finding it quite tough.

This guide from Microsoft
[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;285891[/url]
actually works well and I can understand what's going on, so I've used
it as the basis of my code. However this only deals with a simple set
of records filling a table. My output needs to be a little more
complicated. I'd like to be able to pass several record sets into the
final report rather than using just one very complicated SQL
statement, is this possible? I'd also like to insert a couple of
strings from ASP into the report, how can I do this? And I would like
to cover several workbooks, can I just contain them in a
<xsl:for-each… statement?

If you need more clarification on the problem, or code snippets, then
please just ask

Many Thanks

David Lozzi · David Lozzi

Stick this at the top of the ASP page:

<% Response.ContentType = "application/vnd.ms-excel" %>

<html>
<body>
<table>
<tr>
<td>
</td>
</tr>
</table>
</body>
</html>

And then format the rest of the page with a table. This tag at the beginning
will translate the page into an Excel Spreadsheet.

--
David Lozzi
Associated Business & Technology Group
[url]www.associatedbtg.com[/url]

I should've known that....but I had a brain fart.
"busabus" <drwhiting@hotmail.com> wrote in message
news:358e222f.0308070547.160d558b@posting.google.c om...

> I have an ASP application that uses an Access back end, and basically
> I wanted to get the data into an Excel spreadsheet for reporting
> purposes. I decided to go down the XML route as that gives me good
> formatting options, and allows for multiple workbook pages, and all
> the users have Excel 2002. However I'm finding it quite tough.
>
> This guide from Microsoft
> [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;285891[/url]
> actually works well and I can understand what's going on, so I've used
> it as the basis of my code. However this only deals with a simple set
> of records filling a table. My output needs to be a little more
> complicated. I'd like to be able to pass several record sets into the
> final report rather than using just one very complicated SQL
> statement, is this possible? I'd also like to insert a couple of
> strings from ASP into the report, how can I do this? And I would like
> to cover several workbooks, can I just contain them in a
> <xsl:for-each. statement?
>
> If you need more clarification on the problem, or code snippets, then
> please just ask
>
> Many Thanks

Daniel Whiting · Daniel Whiting

Thanks for that David, it would be quite simply to work the record sets
into html tables, however from my understanding this method doesn't
support multiple worksheets which is required for the reports. If it
does then please correct me and provide the syntax to achieve this.

Thanks

Daniel

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

ASP to Excel. Help with getting data into XML

Thread Tools

Display

ASP to Excel. Help with getting data into XML

Similar Questions and Discussions

Export to Excel has no Data

Excel Data conversion

asp display excel data

Importing Excel data

ADO data into web excel?

Re: ASP to Excel. Help with getting data into XML

Re: ASP to Excel. Help with getting data into XML

Posting Permissions