Hacker News new | past | comments | ask | show | jobs | submit login

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.




That'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.


This is caused by a security update, details and workarounds on the link below

http://www.infoworld.com/article/3098898/microsoft-windows/e...


One 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.


As far as I know there is no Office 2012 (either 2010 or 2013) and the html table trick works on both.


The version numbers for Office on Mac are different to those found on Windows.


Ah ok, didn't think of Mac. thanks




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: