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.
+4
A:
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.
nik
2009-07-07 09:42:24
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
2009-07-07 19:39:19
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
2009-07-08 05:05:18