Skip to content

Instantly share code, notes, and snippets.

@akuks
Created January 9, 2020 19:29
Show Gist options
  • Save akuks/5cc3850c3aee8a8fdba5f9b5a2f1c828 to your computer and use it in GitHub Desktop.
Save akuks/5cc3850c3aee8a8fdba5f9b5a2f1c828 to your computer and use it in GitHub Desktop.
foreach my $sheet ( @{ $excel->{Worksheet} }) {
# skip Sheets if zero rows
next if ( $sheet->{MaxRow} == 0 );
foreach my $row ( $sheet->{MinRow} .. $sheet->{MaxRow} ) {
my $some_var = $sheet->{Cells} [YOUR_ROW] [YOUR_COL]->{Val};
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment