Open existing excel file

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Spreadsheet::WriteExcel This module cannot be used to read an Excel file.

    This module cannot be used to write to an existing Excel file.

    Is there any alternative way to open an existing xls file and
  add worksheets and write to that (open existing xls file , add worksheet and write)

Comment on Open existing excel file

Replies are listed 'Best First'.
Re: Open existing excel file by saintmike (Vicar) on Feb 15, 2005 at 06:10 UTC
Typing `Excel` into the perlmonks Search Box brings up this thread which shows a couple of different ways to read in Excel files.	[reply] [d/l]
Re: Open existing excel file by jmcnamara (Monsignor) on Feb 15, 2005 at 08:40 UTC
Have a look at the following: How do you append to an Excel spreadsheet on Linux. -- John.	[reply]
Re: Open existing excel file by dragonchild (Archbishop) on Feb 15, 2005 at 13:42 UTC
Spreadsheet::ParseExcel is what you're looking for. There are wrappers, such as DBD::Excel and others, but they all use S::PE. Being right, does not endow the right to be rude; politeness costs nothing. Being unknowing, is not the same as being stupid. Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence. Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.	[reply]