How do you extract data using regex from excel sheet in Perl

Question

How do you extract the data using regex in a workbook. For example, I want to extract a set of strings that match a pattern in the workbook which contains many sheets.

score 4 · Answer 1 · edited May 23 '17 at 12:01

4

Install the Spreadsheet::ParseExcel module and,
Look at question converting an Excel (xls) file to a comma separated (csv) file without the GUI.
From there you can use grep on the generated CSV data.

edited May 23 '17 at 12:01

Community

1
1

answered Jul 07 '09 at 09:42

nik

13,254
3
41
57

You don't have to do the conversion to CSV; assuming Perl is what you intend to process in, then the first part of this is all you need to know. That said, the question referenced will have decent example code in. – ijw Jul 07 '09 at 19:39
I guess, I should not have written the last line about using the CSV output for this answer. While that can be done it would be a round-about way. And, I `was` referring to the perl script as an example. – nik Jul 08 '09 at 05:05

score 1 · Answer 2 · answered Jul 07 '09 at 17:24

1

There is a Perl utilty called XLS Tools that allows you to grep an Excel file using Perl command-line idioms. For example:

XLSperl -nle '/pattern/ and print' file.xls

answered Jul 07 '09 at 17:24

jmcnamara

38,196
6
90
108

How do you extract data using regex from excel sheet in Perl

2 Answers2