how to transfer JTable contents to an excel sheet

843807

hello everybody , iam new to this forum
i have the following problem
iam currently developing an Accounting package for
a small office , they want to send the reports generated
by my java program as Excel sheet e-mail attachments to their
head office . is it possible to get data from JTable in to
excel sheet. please kindly offer me a solution/source

843807

Hi,

the simples thing is to save ou table in a file with .txt or .xlt extension. The file must be a standard ASCII file in which the column separator is a TAB.

regards
andreas

mlk

or use POI, http://jakarta.apache.org/poi/index.html

843807

You could always use JDBC. It just takes a little patience to get the connect string just right. But you can create worksheets by doing "Create Table" commands and then insert the data as you would a normal db table.
A common usage is to create an XLS with a worksheet that will contain the data and then other worksheets that would have your reports or pivot tables. Then use the Java app to populate the data in the data sheet.
JMH...

843807

Here is a sample url string that I have used:
String url = "jdbc:odbc:DRIVER={Microsoft Excel Driver (*.xls)};DBQ=c:\\temp\\Budget.xls;";