Java and Excel
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