Web Development



Using OpenOffice to view XML file in Internet Explorer

By neil.chinneck ·
Hi everyone,

We need to be able to read reports which are generated from our client's website. The report is generated on an aspx page in Excel XML format and by default it opens in Excel 2000 (which is on our PC) within an IE browser window to view the report. However, because Excel 2000 doesn't recognise the XML file, all we see is the code, split over several cells. I seem to be able to copy the code, cell-by-cell into a text documents and save it as XML, which I can then open in OpenOffice Calc and save into Excel format. However, this is quite fiddly and sometimes not all the code is generated so I cannot create a complete file.

I would like to know if there is a way of forcing IE to open this page in Calc - I'm not sure if this is even possible. I've set the default program for xml files to Calc but it doesn't make any difference. when I generate the report from the website it doesn't give any option to save the file, it just loads the page. I guess it wasn't designed to be downloadable.

Any thoughts welcome?

If not, I guess we'll have to bite the bullet and get a latest version of Excel. Or get them to tweak the reporting tool.



This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums