Re: Open a file in append mode

What kind of object is stored in $worksheet and what does the documentation of the relevant module say about its ->write method?

You cannot simply mix and match modules that contain "Spreadsheet" or "XLS" in their name and hope that Perl will figure out how you want to use them.

Comment on Re: Open a file in append mode Select or Download Code

Replies are listed 'Best First'.
Re^2: Open a file in append mode by ravi45722 (Pilgrim) on Aug 11, 2015 at 12:41 UTC
Then is there any module to read & write an excel sheet without losing my previous data. (append mode)	[reply]
Re^3: Open a file in append mode by Corion (Patriarch) on Aug 11, 2015 at 13:35 UTC
Also see Spreadsheet::ParseExcel::SaveParser, which (unsurprisingly) comes in the Spreadsheet::ParseExcel distribution. Maybe you want to read the documentation of the modules that you use?	[reply]
Re^4: Open a file in append mode by ravi45722 (Pilgrim) on Aug 12, 2015 at 03:35 UTC
Spreadsheet::ParseExcel::SaveParser working amazingly. Somebody suggested Win32::OLE. Which is more effective and which one is simpler??? Before you said that dont mingle modules. In this `Spreadsheet::ParseExcel::SaveParser` i cant find max_rows & max_col which is available in other modules. As per my requirement I need to insert a row which consists of 11 columns in the end of the sheet. In this Saveparser how to find last row	[reply] [d/l]
Re^5: Open a file in append mode by afoken (Chancellor) on Aug 12, 2015 at 19:08 UTC
Re^5: Open a file in append mode by Corion (Patriarch) on Aug 12, 2015 at 06:44 UTC
Re^3: Open a file in append mode by poj (Abbot) on Aug 11, 2015 at 13:21 UTC
is there any module to read & write an excel sheet Yes, Win32::OLE see Using Win32::OLE and Excel - Tips and Tricks poj	[reply]