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.
About
This page contains a single entry from Stefan Tilkov's Random Stuff posted on May 17, 2006 8:59 AM. The previous post in this blog was A Critical Note on Web 2.0. The next post in this blog is JRuby like Windows on a Mac?. Many more can be found on the main index page or by looking through the archives.
Comments
I’m still totally fond of http://jxls.sourceforge.net/, makes using POI almost a pleasure…
Posted by: wolfgang at May 19, 2006 11:56 PM | link
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
Posted by: Asha M at November 1, 2007 8:21 PM | link