T
Travis
Hello, I have a large amount of data contained within an XML file that needs
to be accessible by developers (for import into a data warehouse, etc) as
well as business staff who require it to be in Excel format (2007) - I am
wanting to dump the XML file onto an FTP site for all users to access (via a
loginId).
With regards to users who need to access the file as though it was Excel, I
was thinking of using a generic XSLT (like the one shown on
http://aspalliance.com/471_Convert_XML_To_an_Excel_Spreadsheet_Using_XSL.all)
to allow it to be imported neatly into Excel. However I don't really know
how it all fits together - as far as I can see, the users should be able to
logon to the FTP site, download the XML file (with perhaps the XSLT file),
then double-click (or import) into Excel - is this possible. I was actually
thinking they could download just one file (the XML file) which would contain
the XSLT information inline (rather than having to download both)
Is this possible - are there any samples.
Many thanks
Travis
to be accessible by developers (for import into a data warehouse, etc) as
well as business staff who require it to be in Excel format (2007) - I am
wanting to dump the XML file onto an FTP site for all users to access (via a
loginId).
With regards to users who need to access the file as though it was Excel, I
was thinking of using a generic XSLT (like the one shown on
http://aspalliance.com/471_Convert_XML_To_an_Excel_Spreadsheet_Using_XSL.all)
to allow it to be imported neatly into Excel. However I don't really know
how it all fits together - as far as I can see, the users should be able to
logon to the FTP site, download the XML file (with perhaps the XSLT file),
then double-click (or import) into Excel - is this possible. I was actually
thinking they could download just one file (the XML file) which would contain
the XSLT information inline (rather than having to download both)
Is this possible - are there any samples.
Many thanks
Travis