Question: how to extract data from excel sheet using perl?
Answer: #!/usr/bin/perl. use 5.010; use Spreadsheet::Read qw(ReadData); my $book = ReadData('simple.xlsx'); say 'A1: ' . $ book->[1]{A1}; my @row = Spreadsheet::Read::row($book->[1], 1); for my $i (0 .. $# row) { say 'A' . ($ i+1) . ' ' . ($ row[$i] // '');