in reply to Delete entire row without using Win32::OLE

Spreadsheet::ParseExcel cannot read XLSX files.

Have you tried simply writing out a new Excel file and omitting the lines you don't want in it? I guess that would be the simplest approach.

Another simple approach would be to use splice on the internal datastructures of your object to remove the rows you don't want. But as you don't show any code and mention the wrong module, I cannot suggest a way of how to do this except that you investigate this yourself.

  • Comment on Re: Delete entire row without using Win32::OLE

Replies are listed 'Best First'.
Re^2: Delete entire row without using Win32::OLE
by ravi45722 (Pilgrim) on Sep 01, 2015 at 13:08 UTC
    In my excel sheet some test cases errors are there. Each error or modification has its own err_id. After rectifying it with the base of err_id (col 1) i want to delete that row from the excel sheet. But i cant able to use Win32::OLE. Can you suggest me how to use splice here.
[reply]

      As I already said:

      But as you don't show any code and mention the wrong module, I cannot suggest a way of how to do this except that you investigate this yourself.
[reply]
        i dont have any code upto now. I have a excel sheet with err_id (col 1), type (col 2), priority (col 3).... etc. In a csv i have err_id's. I want to delete that entire row where the err_id matches from my excel sheet. I googled "How to delete entire row" it redirected to some questions in this site which uses Win32::OLE to delete the entire row. But my RHEL not supporting that. Guide me a module which can delete an entire row
[reply]

In Section Seekers of Perl Wisdom