Java and Excel

EdChouaffe Nov 5, 2011 4:10 PM

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

1. Re: Java and Excel

EJP Nov 5, 2011 10:56 PM (in response to EdChouaffe)

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?
Like Show 0 Likes(0)

Actions
2. Re: Java and Excel

EdChouaffe Nov 6, 2011 8:18 AM (in response to EJP)

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.
Like Show 0 Likes(0)

Actions
3. Re: Java and Excel

EJP Nov 6, 2011 9:03 AM (in response to EdChouaffe)

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.
Like Show 0 Likes(0)

Actions
4. Re: Java and Excel

EdChouaffe Nov 8, 2011 4:24 PM (in response to EJP)

After searching on the internet I found the Apache POI API that enable manipulating Excel file formats with Java.
Like Show 0 Likes(0)

Actions

Go to original post