This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi there, My servlet sets the content type to application/msexcel and writes to an excel spreadsheet, unfortunately when Excel comes up, it doesn't seem to recognize that my output is in csv format, so it puts all of the data per row in the first cell, for example, a row such as 1,2,3 doesn't get broken up into 3 cells, it is all put in the first cell as one string. Any tips on how to get Excel to recoginze the comma seperators? I am setting my content type using: setContentType("application/vnd.ms-excel"); Thanks! Kim
There are two other seperators, you can use: tabs and semikolons. But if you use a newer version of excel, you can generate a html-table and set the mime-type to "application/vnd.ms-excel". this is the best way, because you can view it still in the browser ;) greetings Markus
-----<BR>...may the source be with you
Joined: May 17, 2001
Thank you very much, I wouldn't have thought changing from comma's to semicolons would do the trick but it did. Thanks for your response, Kim
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com