Copying Cells of an Excel Sheets

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

I have an Excel sheet with formulas. I need to copy few cells. Is there any module which can do this because Spreadsheet::ParseExcel cant read formulas.

Or is there any module which have command for copying all the data from 1 cell to another whether its a string or number or formula or macro. I am using CentOS (Linux)

Comment on Copying Cells of an Excel Sheets

Replies are listed 'Best First'.
Re: Copying Cells of an Excel Sheets by Anonymous Monk on Feb 06, 2014 at 09:37 UTC
Problem Writing macros in an Excel File	[reply]
Re: Copying Cells of an Excel Sheets by Mr. Muskrat (Canon) on Feb 06, 2014 at 18:40 UTC
Take a look at Spreadsheet::ParseXLSX for reading in the data. Take a look at Excel::Writer::XLSX for how to extract macros and write new spreadsheets.	[reply]

Back to Seekers of Perl Wisdom