Re: does Spreadsheet::WriteExcel only create new files?

Replies are listed 'Best First'.
Re^2: does Spreadsheet::WriteExcel only create new files? by trickyq (Acolyte) on Jun 06, 2012 at 20:33 UTC
can you show me some syntax, I am terrible with the cpan docs. I need to see what it looks like, or could you refer me to a specific place where I can read how to specifically write to an excel file. Even if its real general, I can figure it out. I just read the Win32::OLE module docs for a while and then tried some stuff. I cant figure out how to tell it to open the existing workbook and write to it.	[reply]
Re^3: does Spreadsheet::WriteExcel only create new files? by runrig (Abbot) on Jun 06, 2012 at 21:43 UTC
Spreadsheet-WriteExcel (or Excel::Writer::XLSX, which I recommend over S::PE unless you really need the old format xls files). Click on 'Browse'. Goto 'examples'.	[reply]
Re^3: does Spreadsheet::WriteExcel only create new files? by dasgar (Priest) on Jun 06, 2012 at 20:51 UTC
Are you on a Windows system that has Excel and Perl installed? If not, you're not going to be able to use Win32::OLE. If you are on a Windows system with Perl and Excel, you can check out Using Win32::OLE and Excel - Tips and Tricks or do a super search on "excel win32 ole" to get started on using Win32::OLE to control Excel.	[reply]
Re^4: does Spreadsheet::WriteExcel only create new files? by patcat88 (Deacon) on Jun 09, 2012 at 18:45 UTC
Can Wine and Perl be used together so MS Office docs can be opened on Linux?	[reply]
Re^5: does Spreadsheet::WriteExcel only create new files? by thomas895 (Deacon) on Jun 09, 2012 at 19:45 UTC