> On Oct 29, 2015, at 2:58 PM, Craig A. Berry <[email protected]> wrote:
> Now it runs but creates empty files. I’ll have to look into that sometime
> but have to get back to real work at the moment.
Oh, for goodness sake, when are these messages ever going to make it through
moderation and show up on list?
I got somewhat farther by setting this:
$ DEFINE DECC$FILENAME_UNIX_REPORT 1
and testing with [.examples]demo.pl, but the resulting file is corrupt. Since
an xlsx file is just a zip file containing a bunch of different Excel-specific
files, you can examine its contents with unzip. Here’s what’s in it when
created on VMS:
$ unzip -l demo.xlsx
Archive: demo.xlsx
Length Date Time Name
-------- ---- ---- ----
848 10-29-15 17:49 docProps/app.xml
592 10-29-15 17:49 docProps/core.xml
606 10-29-15 17:49 xl/sharedStrings.xml
1992 10-29-15 17:49 xl/styles.xml
652 10-29-15 17:49 xl/workbook.xml
1018 10-29-15 17:49 xl/drawings/drawing1.xml
291 10-29-15 17:49 xl/drawings/_rels/drawing1.xml.rels
6263 10-29-15 17:49 xl/media/image1.png
6995 10-29-15 17:49 xl/theme/theme1.xml
1802 10-29-15 17:49 xl/worksheets/sheet1.xml
438 10-29-15 17:49 xl/worksheets/sheet2.xml
438 10-29-15 17:49 xl/worksheets/sheet3.xml
460 10-29-15 17:49 xl/worksheets/_rels/sheet1.xml.rels
979 10-29-15 17:49 xl/_rels/workbook.xml.rels
587 10-29-15 17:49 _rels/.rels
-------- -------
23961 15 files
Here’s what’s in it when created on OS X:
$ unzip -l demo.xlsx
Archive: demo.xlsx
Length Date Time Name
-------- ---- ---- ----
1609 10-29-15 18:02 [Content_Types].xml
587 10-29-15 18:02 _rels/.rels
848 10-29-15 18:02 docProps/app.xml
592 10-29-15 18:02 docProps/core.xml
606 10-29-15 18:02 xl/sharedStrings.xml
1992 10-29-15 18:02 xl/styles.xml
652 10-29-15 18:02 xl/workbook.xml
979 10-29-15 18:02 xl/_rels/workbook.xml.rels
1018 10-29-15 18:02 xl/drawings/drawing1.xml
291 10-29-15 18:02 xl/drawings/_rels/drawing1.xml.rels
6263 10-29-15 18:02 xl/media/image1.png
6995 10-29-15 18:02 xl/theme/theme1.xml
1802 10-29-15 18:02 xl/worksheets/sheet1.xml
438 10-29-15 18:02 xl/worksheets/sheet2.xml
438 10-29-15 18:02 xl/worksheets/sheet3.xml
460 10-29-15 18:02 xl/worksheets/_rels/sheet1.xml.rels
-------- -------
25570 16 files
Nothing looks greatly amiss in the VMS version except that the oddly named file
[Content_Types].xml is missing. The file does exist in the temp directory on
VMS:
$ dir/size [...]^[Content_Types^].xml;1
Directory MDA0:[CRAIG.SCRATCH.bGENbxoyB2]
^[Content_Types^].xml;1
3
Total of 1 file, 3 blocks.
so something is preventing that file from getting added to the zip/xlsx
archive. That’s got to be happening somewhere around here:
https://github.com/jmcnamara/excel-writer-xlsx/blob/master/lib/Excel/Writer/XLSX/Workbook.pm#L962
and needs further investigation.
________________________________________
Craig A. Berry
mailto:[email protected]
"... getting out of a sonnet is much more
difficult than getting in."
Brad Leithauser
