wood burning stoves 2.0*
The moose likes Java in General and the fly likes Excel Sheets Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "Excel Sheets" Watch "Excel Sheets" New topic

Excel Sheets

Ahmed Haboubi
Ranch Hand

Joined: Oct 21, 2000
Posts: 36
I need to generate an Excel sheet from a Java application. Is this possible? If so, what is the method?
Thanks in advance.
Sean MacLean
Ranch Hand

Joined: Nov 07, 2000
Posts: 621
Do a search on all the forums and you should find lots of info on this topic. I believe it is a simple as 'pipe' or comma delimiting a text file.
karl koch
Ranch Hand

Joined: May 25, 2001
Posts: 388
easiest way is to generate a CSV file (comma separated values).
create a text file with .csv extension and write your values separated by ',' or ';' in it. like:
10.0990, 9090.1,1000
23, 3434.322, 9090909090
and so on.
if you need to write real excel stuff with formulas and formating, then this wont work.
hope this helps.
It is sorta covered in the JavaRanch Style Guide.
subject: Excel Sheets
Similar Threads
OutOfMemory error
WA #1.....word association
Problem in retrieving Cell values from Excel file.
Record Export?
JasperReports -- excel issue