How can I use Perl to delete a row in an Excel file?

Question

I have to delete a line which contain zero in two columns. How do I do that?

Punctuation, capital letters. Furthermore, do not just ask for code, but show us what you've tried. — Powertieke, Sep 24 '10 at 06:38

score 3 · Answer 1 · edited Sep 24 '10 at 16:13

3

No, but I can point you in the right direction.

The Win32::OLE module can help with scripting Excel and other Windows apps in Perl. I'm assuming you have Excel installed.

edited Sep 24 '10 at 16:13

brian d foy

answered Sep 24 '10 at 06:36

Powertieke

Here's a great summary of all the commands to manipulate Excel from perl via Win32:OLE http://stackoverflow.com/questions/27613878/list-of-perl-commands-to-manipulate-windows-excel-with-win32ole-module – Matthew Lock Jan 23 '17 at 07:49

score 1 · Answer 2 · answered Sep 24 '10 at 15:32

1

You can also use CPAN modules Spreadsheet::WriteExcel and Spreadsheet::ParseExcel Perl modules to manipulate excel.

answered Sep 24 '10 at 15:32

ppant

2 Answers2