Help for this page

Select Code to Download


  1. or download this
    my $book = ReadData ("file.xls");
my $book = Spreadsheet::Read->new ("file.xls");
  2. or download this
    Spreadsheet::Read::add ($book, "file.csv");
$book->add ("file.csv");
  3. or download this
    $book->add ("file.csv", label => "Testing");
  4. or download this
    my $sheet = $book->sheet ("Test"); # or numbered
my $maxcol = $sheet->maxcol;
...
$sheet->label ("New label");
my @row = $sheet->row (2);
my @col = $sheet->col (6);
  5. or download this
    # suggestions
$sheet2->copy ("C5", $sheet1->block ("F6", "H20"));
$sheet->deleterow (12);
$sheet->deletecol ("D" .. "F");
$sheet->block ("A1", "D5", sub { ... });