On Jun 6, 2012, at 1:54 PM, Ken Furff wrote: > apparently win32::OLE can be used to write to an existing spreadsheet. I have > read the cpan docs and tried a hundred things, but I cant seem to get the > syntax right.
Win32::OLE doesn't write spreadsheets, but it does try to control the Excel application and get it to do your bidding. You probably need to have the Excel application running under Windows to make this work (I haven't tried it). > I'm going to post this script one more time. Your script doesn't use Win32::OLE properly. Please refer to the documentation for this module. Also, check out the Spreadsheet::TieExcel, which uses Win32::OLE to modify an existing spreadsheet by utilizing the Excel application. -- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] http://learn.perl.org/
