This is a single archived entry from Stefan Tilkov’s blog. For more up-to-date content, check out my author page at INNOQ, which has more information about me and also contains a list of published talks, podcasts, and articles. Or you can check out the full archive.

Download HTML as Excel Sheet

Stefan Tilkov,

Bob DuCharme explains a neat trick to provide an “Excel export”, based on sending HTML with an appropriate MIME type. I remember one of my colleagues using this trick in a project; much easier than any POI or other more complex solution, and often just as effective.

On May 19, 2006 11:56 PM, wolfgang said:

I’m still totally fond of http://jxls.sourceforge.net/, makes using POI almost a pleasure…

On November 1, 2007 8:21 PM, Asha M said:

Bob, When you “export” and HMTL table in this way, are there any limitations to the amount of data in each cell?

Our HTML table will contain a cell with nearly 6 pages of data. What will be the limitations opening up a the file in Excel?

Thank you for a quick response, Asha