User Profile

Collapse

Profile Sidebar

Collapse
testingPerl
testingPerl
Last Activity: Jan 25 '10, 06:14 AM
Joined: Jan 21 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • testingPerl
    replied to Having trouble with Spreadsheet::Read hash
    in Perl
    Yessssss, Thank you so much!

    I will be sure to come back here if I have any more questions. The if loop helped me figure out how to check if any cells contain the word "test":

    Code:
    #!/usr/bin/perl -w

use strict;
use Spreadsheet::Read;
use Data::Dumper;

my $xls = ReadData ("test.xls");


for my $cell (map { "A$_" } 1 .. 100) {
    ...
    See more | Go to post

      Leave a comment:

    • testingPerl
      started a topic Having trouble with Spreadsheet::Read hash
      in Perl

      Having trouble with Spreadsheet::Read hash

      Hey everyone. I'm using Spreadsheet::Re ad to grab data from an excel .xls file and I can't figure out how to loop through the hash and display the data. Using print works but I would like to print column A1 through A100 without having to manual type them all out. I tried a lot of different things so any help would be really appreciated. Here is the code I've got so far:

      Code:
      #!/usr/bin/perl -w

use strict;
use Spreadsheet::Read;
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...