tags:

views:

34

answers:

2
Q: 

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

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

+2  A: 

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.

Powertieke  2010-09-24 06:36:05
A: 

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

ppant  2010-09-24 15:32:03

related questions

Regex to replace Boolean with bool
How do I lock a file in Perl?
How do you use XML::Parser with Style => 'Objects'
Parsing XML Elements & Attributes with Perl
Regex to match all HTML tags except <p> and </p>
Best way to extract data from a FileMaker Pro database in a script?
What's the fastest way to determine a full URL from a relative URL (given a base URL).
Why can't I connect to my CAS server with Perl's AuthCAS?
Why can't I fetch wikipedia pages with LWP::Simple?
How do I perform a Perl substitution on a string while keeping the original?
How do I read in the contents of a directory in Perl?
How can Perl's system() print the command that it's running?
How can I test STDIN without blocking in Perl?
How do I tell if a variable has a numeric value in Perl?
Why doesn't my Perl map return anything?
How can I determine the type of a blessed reference in Perl?
Parsing attributes with regex in Perl
How do you retrieve selected text using Regex in C#?
Why does the Perl conditional operator not do what I expect?
Class::DBI-like library for php?
How do you create objects in Perl?
How do I remove duplicate items from an array in Perl?
Is The Perl Journal available online?
Can you force either a scalar or array ref to be an array in Perl?
What's the safest way to iterate through the keys of a Perl hash?