Parsing XML in ASP and output as Excel

XML string as Input to ASp and Excel file as Output

[mathew]

Hi,
I am having an XML file which is the output of some report data from the database.I need to know how to use ASP to parse this XML and generate an Excel sheet as output to a user.This should work with all browsers and all version of excel.
Help much appreciated

Thanks
Mat

[JamesR]

Hi mathew,

welcome to the forums and thanks for posting.

I don't use the technology you describe, but maybe someone else around here has some input?

[mathew]

Thanks.
Yes I am still waiting for a reply.

mathew

[mikeputnam]

matthew:

I believe the Office XP version of Excel has built-in XML capabilities. You could probably just use the raw XML file without needing to convert to .xls

Read this MS page for more details...
[microsoft.com...]

[Dreamquick]

I've used vb to create a sheet programatically before so it shouldnt be too much of a leap to make vbscript do it.

However I'd suggest that you should look at using a server side component to create the excel spreadsheet from the xml data and then once the component returns a result you could then let the user download said spreadsheet.

I'd prefer to use VB rather than VBScript to achieve this simply because I find it easier to deal with high-level objects using that rather than vbscript.. the Excel DOM isn't a tricky beast to master so after an initial test you should be able to create a nice little component with very little trouble.

- Tony