my $data = $cell->value();
This is how I parse in perl and then get the cell value. if the cell value is a blank , I want to skip that cell and move further. but its not excuting once it finds a blank cell.
please help
einstein
Last Activity: May 19 '14, 10:12 AM
Joined: Apr 7 '14
Location:
-
Skipping blank cells in excel
-
Fetch table from Micorsoft Access database
Hi,
My access database is having a alsmost 20 tables inserted and each table having numerous columns. I want to fetch only certain columns from a table and then compare them using perl.
I am able to compare the columns in excel but I dont want to export and compare I want to access the database only.
Any ideas. -
sorry for the late reply Miller, but i was messed up pretty bad in the same stuff. Now I'm through and thanks to you I got the initiation atleast.
Do you by any chance how to use perl to fetch tables from microsoft access database. I ve been thinking to advance this a level up now. rather than comparing the excel if i directly fetch from access database and compare. Any ideas you can share would be very useful. -
compare excel sheets
Hi,
I'm new to perl.
I want to compare two excel sheets the second excel file is just the revised version of the first one. There are only two columns each file with a certain number of Rows
The following code is just printing all the values in it
...Code:use strict; use warnings; use Spreadsheet::ParseExcel; use Spreadsheet::WriteExcel; my $parser = Spreadsheet::ParseExcel->new();Last edited by Rabbit; Apr 7 '14, 05:03 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: