3

Perl : blank lines are displayed in the output after deleting few rows from excel

view full story
linux-howto

http://www.unix.com – I am working on an assignment to pull all the records from excel sheet programatically and use the data for further calculations. In this process, I first defined 10 records in excel sheet and executed the below code. In the first run it is OK. But after deleting last few rows in excel sheet and then running, blank lines are displayed at the end. Code: #!C:\perl\bin –w     use strict;     use Spreadsheet::ParseExcel;     my $FileName = "C:/pro1/birthdays.xls";     my $parser  = Spreadsheet::ParseExcel->new();     (HowTos)