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.
well dear You can surely format them, in case of Excel, set the proper content type & while outputting the data, dont start with standard HTML tags but only start with "<table><tr><td>" & so on... this will help you to format the Excel tables... with WORD you can format as standard text. hth MB
There is a jakarta project called POI. It's a java API for manipulating MS file formats. It include several subprojects, like the Horrible Document Format (For MS-WORD format) and the Horrible Spreadsheet Format (for Excel files). You can find more info in the POI website: http://jakarta.apache.org/poi/ For manipulating Excel files, there is another solution: You can do it using JDBC. MS provides an ODBC driver for Excel, so you can use JDBC and the Sun JDBC-ODBC driver to read Excel files. Check the Javaworld Java/Microsoft Excel series: http://www.javaworld.com/javaworld/javaqa/2001-06/04-qa-0629-excel.html
Joined: Jan 23, 2002
Thanks all, I've tried output simple information as XLS or WORD doc. (It's Strange that with <html> I can still the displayed format in the xls file) Another idea comes, you know, an excel file can consist of several spreadsheets, if I want to do this, must I need to use the POS mentioned by Juanjo Bazan ? Thanks
I also need a servelt to generate a word doc. It did when i set the contenttype to application/msword .But when it got saved it dint save with a .doc.I had to open with ms word. .I need it to have .doc format so that i can print it. do help. thanks