Re: Transistor Counting from Excel Sheet.

[roboticus]

jumdesumit:

I'd suggest installing Spreadsheet::ParseExcel on your machine, and reviewing the example code and/or test code to see how to read from the spreadsheet.

From there it's a simple matter to gather the data and compute the counts you're wanting.

...roboticus

When your only tool is a hammer, all problems look like your thumb.

[tel2]

I don't think Spreadsheet::ParseExcel will work, because jumdesumit refers to an xlsx file (Transiotr_count.xlsx) and the description of Spreadsheet::ParseExcel says:
"The module cannot read files in the Excel 2007 Open XML XLSX format. See the Spreadsheet::XLSX module instead."

The "fun" bit might be reading the docx files (e.g. cell_report.docx), since there may be no modules which support the docx format, but pryrt's links above about docx may help.
However, I've just tried this code for Windows (which uses Win32::OLE & Win32::OLE::Enum) and it successfully read my simple .doc and .docx files!  I wonder if there's a Linux alternative.

[roboticus]

tel2:

That's a good point! I still suggest reading the examples from Spreadsheet::ParseExcel, but you're right that he'll want to use Spreadsheet::XLSX for his project, or one of the native Win::OLE ones.

...roboticus

When your only tool is a hammer, all problems look like your thumb.