A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Java in General
how to export data to Excel
Joined: Apr 20, 2004
May 26, 2005 08:06:00
, how to export data to MS-EXCEL
Joined: Dec 29, 2004
May 26, 2005 08:25:00
file format, construct a properly formed file in a byte, and write it out to a file.
Or you might want to look at a third party library like
There may be a way through ODBC, but I've never tried it and you still might need some additional library.
[ May 26, 2005: Message edited by: Steven Bell ]
Joined: Oct 29, 2001
May 26, 2005 08:36:00
I've had success creating a comma-seperated text file and naming it something.csv. Excel is associated with the CSV extension so it will open the file if you click on it in Windows Explorer.
How To Ask Questions On JavaRanch
Joined: Jun 07, 2003
May 26, 2005 09:51:00
Originally posted by Ramakrishnan:
In core java, how to export data to MS-EXCEL
I've had Excel-lent (sorry!) success with the already-mentioned jakarta poi hssf project. Go get poi. There's working sample code in the docs.
Have you checked out
subject: how to export data to Excel
Exporting Data (Excel to Oracle)
save a report as an excel file
exporting to CSV
CSV file opening in Excel - cell auto adjustment using JasperReports
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015