How to convert multiple Excel sheets into one PDF file. Click the first sheet tab that you want to use. CTRL-click each additional tab to print, or SHIFT-click the last tab, if you want to use all tabs. Click File, Print. Select Microsoft Print to PDF or another PDF printer. Choose to print All Selected Sheets. Choose other options as needed. Click Print. Youâll be prompted for where to save the file, and for what name to give the file. Click Save. When youâre done, RIGHT-click on any of your selected tabs and choose Ungroup Sheets. This is important. If you donât ungroup them, any change that you make to a cell on one sheet will be made to that cell on all sheets. For example, if the sheets are still grouped, and you change cell C5 on the first sheet, you will have also changed C5 on the other sheets.
So if someone decides to create another Excel/VBA/TextWrangler like library. They could also create one to read the above formats but for doing so they would certainly need to read the XML in Excel and then convert from that to XML or XML to excel. So you could write the same code at this level as well. But then it's up to the external library developer to provide a utility that will handle the parsing and decoding of the XML and Excel formats at the application level. In any case, I did not see anything for parsing excel XLSX files for Java using the above-mentioned libraries, but I see some existing Java libraries (but not used any actual data) that can do something like this. As to Excel XLSX files being XML, well, that would depend on whether the file is used as a data file in Excel or as.