python - Parsing an excel file without library -
i trying parse excel spreadsheet contains information in each row. need extract specific information each row, , work information.
namely, each row of format a, b, c, d, e, , variable 'c' repeated in each row of spreadsheet, need extract 'c' each row , able count number of 'c's.
i apologise not posting code - not able to, plagiarise me.
any or ideas on how go appreciated.
it difficult without form of example. think use count.if formula
=countif(a2:a5,"conditions true if format type c")
look @ examples can find in documentation page...or post example. extract values use combination of mid, midb, search, ... functions.
Comments
Post a Comment