-
Notifications
You must be signed in to change notification settings - Fork 10
Preparing excel files
So in the beginning of everything there's a excel file. The Open XML is pretty complex, so it's easier just to create your excel file prior actual generation. You should prepare the excel file including all macros, printer settings etc., which you want to use in the final report. We will be picking everything one-by-one afterwards.
For the purposes of this documentation, we will be generating the same file as the one, that gets generated by this XSL Engine by default.
Once you prepare your excel template, unzip it. Do not delete the excel file, as the process is quite sensitive - so you want to keep it around up until it gets fully generated by your system.
Navigate to unzipped folder, and you should see a directory structure. As the structure is quite large, we will list only files that interest us:
- xl/drawings/drawing1.xml - only when you have added at least one image
- xl/media/imageX.jpg - only when you have added at least one image
- xl/printerSettings/printerSettings1.bin - only when you have defined printer settings
- xl/theme/theme1.xml
- xl/worksheets/sheet1.xml
- xl/sharedStrings.xml
- xl/styles.xml
- xl/vbaProject.bin - only when you have macro-enabled workbook
You might not see every single file, depending on the worksheet you have prepared. In our case, we have seen all of these, but we marked bold the ones, which are always present.