Java and Excel

EdChouaffe

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

EJP

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?

EdChouaffe

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.

EJP

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.

EdChouaffe

After searching on the internet I found the Apache POI API that enable manipulating Excel file formats with Java.