I know that this PEAR package is no longer supported, and I'd LOVE to change all my programming to use something else. But for a variety of reasons, that's just not an option for me. So I'm hoping someone out here has a little more experience than I do with this particular package, and can offer some guidance.
I'm using this package to generate some very large spreadsheets. I think in some scenarios I'm hitting a maximum number of colums or something. I found a few references online to there being a 255 column cap, and my spreadsheet in question has 256 columns that are complete. But then the next 25 that should have something in them from my code are all blank. And after I write all the columns, then I add another rows to the worksheet and that part works as well. But I'd like to know what kind of error the Spreadsheet_Excel_Writer package is generating when it tries to write to that cell but can't. Anyone out there know how to generate an error message from the $spreadsheet->write() command?
Better yet... if anyone knows how to overwrite / set the maximum number of columns allowed in the Spreadsheet_Excel_Writer PEAR package, that would be awesome!!! What I have now works so well for most of our clients in so many scenarios. But I seem to have hit a wall with the maximum number of columns, and I'd like to be able to confirm if this is the problem or not. In this scenario, that's the next-to-last sheet in my workbook, and the last one is perfect. And I've used my same code to generate other spreadsheets using the Spreadsheet_Excel_Writer PEAR package that are far larger, so I know that I'm not just hitting a max filesize either - at least not for the complete file. Maybe there's a max filesize per sheet though?
Please advise,
Shaun
