Download HTML as Excel Sheet

, May 17, 2006

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, 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