This content has been marked as final. Show 4 replies
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.