Parse excel file with using Perl

Question

I'm quite new in perl, so I'm asking for tips for the problem below : I have a excel file and I want to search for specific words in column title (1st row) then if it matches I extract the entire column and put it in a array (or whatever else).

So in my array, I will have first column then 2nd etc... until the end of the search.

I'm intending after that to read my array line by line to process data in order (I'm confortable for that part).

thanks

State exactly the problem. You want to know howto parse `xls` or process the data in arrays? — Darek, Oct 24 '12 at 20:31
I want to extract columns based on match on their title (first row). — Dakar, Oct 29 '12 at 20:13

score 1 · Accepted Answer · answered Oct 24 '12 at 20:17

1

Take a look at Spreadsheet::Read. It reads the whole Excel sheet in an array-hash-ref, which you can search.

answered Oct 24 '12 at 20:17

Demnogonis

3,172
5
31
45

This is just about as good an answer as you're going to get for this question. – Len Jaffe Oct 24 '12 at 20:25
You're welcome :) . Please accept the answer that worked for you, by clicking the green tick next to it. – Demnogonis Oct 31 '12 at 13:48

score 0 · Answer 2 · answered Oct 24 '12 at 20:26

0

Look at Spreadsheet::Read. The results come out $ref->{cell}->[arrayref_of_columns] so you can match against index [1] of that array ref and if it matches, that whole arrayref is your column.

answered Oct 24 '12 at 20:26

jshy

111
6

score 0 · Answer 3 · answered Oct 24 '12 at 20:34

Personally, I always prefer to export Excel files to XML format using Save as->XML Spreadsheet 2003 and use XML::Simple. However, there are a few Excel parsers too.

Spreadsheet::ParseExcel and Spreadsheet::XLSX, of which you probably want the latter.

NOTE: I haven't used ReadExcel, but it looks good too.

Parse excel file with using Perl

3 Answers3