in reply to Transistor Counting from Excel Sheet.

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.

  • Comment on Re: Transistor Counting from Excel Sheet.

Replies are listed 'Best First'.
Re^2: Transistor Counting from Excel Sheet.
by tel2 (Pilgrim) on Feb 08, 2018 at 00:20 UTC
    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.

[reply]

      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.

[reply]

In Section Seekers of Perl Wisdom