3 ms·
Laziest way to output an excel file: Write an html table to a file and make the extension ".xls" This has the minor niggle that it will throw a warning to the
by glaberficken 10y ago
Laziest way to output an excel file:
Write an html table to a file and make the extension ".xls"
This has the minor niggle that it will throw a warning to the user ("The file format and extension of *.xls don't match...")
But it has the "advantage" over the csv approach that you can include formatting via hmtl/css styles.
- laumars 10y agoOne of our history systems did that, but it doesn't work with the Office 2012. There is an XML format that worked with the pre-OOXML versions of Office and should continue to work with moderns versions as well. Plus it's a drastically simpler file format than the complex zipped XML-cluster of files that describe XLSX documents.
- glaberficken 10y agoAs far as I know there is no Office 2012 (either 2010 or 2013) and the html table trick works on both.
- ZenoArrow 10y agoThe version numbers for Office on Mac are different to those found on Windows.
- glaberficken 10y agoAh ok, didn't think of Mac. thanks
- space_ghost 10y agoThat's broken now in Office 2013 and Office 2016. Several of my users -at the same time- found that they could not open "excel" documents provided by several different vendors, all of which were actually HTML tables in files named ".xls". My guess is that Microsoft broke this with a software update, but I've yet to research the problem.
- glaberficken 10y agoThis is caused by a security update, details and workarounds on the link below http://www.infoworld.com/article/3098898/microsoft-windows/excel-refusing-to-open-files-blame-the-kb-3115322-3115262-security-updates.html http://www.infoworld.com/article/3098898/microsoft-windows/e...