Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Java and Excel

EdChouaffe
Member Posts: 125
Hi guys,
I have come to a point in my Application (that I'm writing in Java) where I need to create XML files that can be read with Excel (the spreadsheet editor of Microsoft or something similar). The problem arises when it comes to writing an XML file that comes up with multiple worksheets when opened with Excel. There is actually no way to break an XML file so that Excel will recognize it as containing multiple worksheets. The Excel file will just be one worksheet.
I though perhaps there is a Java API for Excel that can handle things like creating Excel files, creating multiple worksheets in a workbook etc..
Do you know of any API that can do that? A quick search on google yields JExcelAPI. Is it a good one?
Thanks.
Edmond
I have come to a point in my Application (that I'm writing in Java) where I need to create XML files that can be read with Excel (the spreadsheet editor of Microsoft or something similar). The problem arises when it comes to writing an XML file that comes up with multiple worksheets when opened with Excel. There is actually no way to break an XML file so that Excel will recognize it as containing multiple worksheets. The Excel file will just be one worksheet.
I though perhaps there is a Java API for Excel that can handle things like creating Excel files, creating multiple worksheets in a workbook etc..
Do you know of any API that can do that? A quick search on google yields JExcelAPI. Is it a good one?
Thanks.
Edmond
Answers
-
There is actually no way to break an XML file so that Excel will recognize it as containing multiple worksheets.That doesn't sound correct at all. How does Excel do it?
-
So let me correct myself.
I couldn't actually figure out a way to break an XML file so that Excel will recognize it as containing multiple worksheets. -
I suggest you start from the other end. Create an Excel file with multiple spreadsheets, save it as .xlsx, and see how it's done.
-
After searching on the internet I found the Apache POI API that enable manipulating Excel file formats with Java.
This discussion has been closed.