So I have an Excel workbook with three Worksheets that is basically a weekly executive summary of a lot of data in a postgresql database -
The main Worksheet will eventually have 12 data columns and I will use the Month as the offset. . While worksheet2 is also updated and the content in Worksheet 3 is replaced.
The source of the data is currently a series of SQL selects that all output to a text file, and then someone, namely me, has to update the Workbook and send the updated result to an Exchange group for distribution. Obviously the goal is to automate this and run it out of Cron weekly.
I moved the xlsx to my FreeBSD server and using unzip pulled apart the xlsx. But there are a lot of components and it' s not obvious how for example the "sharedStrings.xml" is updated in relation to the worksheets/sheet1.xml files.
Hoping someone may have a link to a whitepaper or book that would give me better insight into the relationships here, and on how to work with these files before I zip them back up and distribute them.