How can I add a new row between two existing rows in a excel file using perl?

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

I want to modify an existing excel file using Perl. So, right now I am using the Spreadsheet::ParseExcel::SaveParser for that. Using the Addcell command I am able to modify any cell. But now I want to add new rows between two existing rows which I am unable to do.

This question is cross-posted on stackoverflow :

https://stackoverflow.com/questions/56362825/how-can-i-add-a-new-row-between-two-existing-rows-in-a-excel-file-using-perl

2019-07-01 Athanasius linkified the link

Comment on How can I add a new row between two existing rows in a excel file using perl?

Replies are listed 'Best First'.
Re: How can I add a new row between two existing rows in a excel file using perl? by betmatt (Scribe) on Jun 26, 2019 at 15:57 UTC
Do you have access to a database like MySQL? You would be better doing all those sort of transformations by interacting with a SQL database using Perl DBI. Once you have a CSV file with transformed data you can always put that back into a pre-set spreadsheet.	[reply]