-
Notifications
You must be signed in to change notification settings - Fork 11
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 the SDK.
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. We will mark in bold the files, that interest us (the italic ones are generated by the XSL engine itself.)
- _rels/.rels
- docProps/app.xml
- docProps/core.xml
- xl/_rels/workbook.xml
- xl/drawings/_rels/drawing1.xml.rels
- xl/drawings/drawing1.xml
- xl/media/image1.jpg
- xl/printerSettings/printerSettings1.bin
- xl/theme/theme1.xml
- xl/worksheets/_rels/sheet1.xml.rels
- xl/worksheets/sheet1.xml
- xl/sharedStrings.xml
- xl/styles.xml
- xl/vbaProject.bin
- xl/workbook.xml
- [Content_Types].xml