Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 390 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
how to transfer JTable contents to an excel sheet

843807
Member Posts: 46,582
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
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
Comments
-
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 -
or use POI, http://jakarta.apache.org/poi/index.html
-
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... -
Here is a sample url string that I have used:
String url = "jdbc:odbc:DRIVER={Microsoft Excel Driver (*.xls)};DBQ=c:\\temp\\Budget.xls;";
This discussion has been closed.