Daniel Wilson wrote: > I believe, I have hit the limit of Spreadsheet::WriteExcel. > > I have built (using Spreadsheet::WriteExcel) a workbook with seven > sheets containing data from numerous sources and hit a brick wall. I > need to add six additional sheets of embedded charts, using the data > on the previous already built sheets. Based on the > Spreadsheet::WriteExcel documentation, it does not support embedded > charts, nor does it support Excel macro. One option was to use the > Excel Macro to build the embedded charts. However > Spreadsheet::WriteExcel again doesn't support macros. I thought > about using some type of Excel merge, whereabout two excel workbook > (one with data and one with just embedded charts) are joined > together. However no success so far. > > Anyone has any ideas?
You could try Win32::OLE. If you can do it in an Excel macro, you can probably do it via OLE. (In fact, I generally don't write Word or Excel macros anymore - perl is somewhat more powerful than basic :-) It helps that the Win32::OLE module comes with decent examples. Watch out for these: 1) OLE is not that quick. Don't use OLE to populate large worksheets. 2) OLE has bugs, especially with Office 97. Office 97 OSR 1 helps, and the later versions are also better. That said, I use Win32::OLE all the time for manipulating documents and spreadsheets. Regards Michael _______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
