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

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.
  • Comment on Re: How can I add a new row between two existing rows in a excel file using perl?