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.
"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
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.
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-2014