|laziness, impatience, and hubris|
Re^3: Not sure why perl-generated spreadsheet has formatting issuesby Athanasius (Canon)
|on Sep 18, 2012 at 09:06 UTC||Need Help??|
I can think of only two ways to write formatted dates into an Excel spreadsheet using Excel::Writer::XLSX:
Is it possible for me to send you the output file I was able to generate?
No, but I don’t see how that would help anyway. It would be much more useful for you to show the code you used, and just describe the resulting output.
...if I generate a pivot table...
According to the documentation, Excel::Writer::XLSX does not (yet) support the generation of pivot tables — this is mentioned in the TO DO section. So, how are you generating pivot tables?
Perhaps the best advice I can give is that you investigate alternative CPAN modules for writing Excel. :-(
Athanasius <°(((>< contra mundum