• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exporting from Java to MS Word and MS Excel

 
Trinity Graham
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi! Is it possible to export data from a Java application to MS Word and MS Excel? If it's possible, how do you do it? We are currently working on a project that uses Java and our application needs to generate reports in MS Word aand MS Excel. Unfortunately, I am completely clueless how to go about this report generation thing. Could anyone please help me? Do you know of any sites where I can get specific information on how to export data from java to MS Word and Excel? Thanks so much.
 
Michael Ernest
High Plains Drifter
Sheriff
Posts: 7292
Netbeans IDE VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The easiest way to do this for Excel is to output your data as comma-separated values, and pop a .csv on the end of the file name. Excel recognizes this format and will tabularize it for you, but be careful about fields with internal whitespace -- Excel may not handle those as you'd expect.
I'm not sure what you mean by Word format. Do you also want a table for that?
------------------
Michael Ernest, co-author of: The Complete Java 2 Certification Study Guide
 
Kris Nelson
Ranch Hand
Posts: 35
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I may be crazy, but I remember reading that MS Word actually uses XML for formatting it's documents. I'll try to track down the source, but if someone else has heard of such a thing, back me up.

------------------
WebNelly.com
Java/XML Web Development
Check it out!
http://www.webnelly.com
 
Colin Kenworthy
Ranch Hand
Posts: 88
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Word can open a .htm or .html file so you could create/format your report with standard html tags.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic