Jul-13-2022, 11:28 AM
Hello,
Here is a snippet on how to access rows in the worksheet.
The type of the "rows" object is odict_values.
Converting it to a list (i.e. list(rows)) results in a list within a list, e.g. [[['aaa', 'rrr'], ['bbb', 'ztutrutr'], ['cccc', 'zuzu'], ['ddd']]].
Is there a smart way to access spreadsheet content to avoid quite large list processing.
Thanks.
Here is a snippet on how to access rows in the worksheet.
The type of the "rows" object is odict_values.
Converting it to a list (i.e. list(rows)) results in a list within a list, e.g. [[['aaa', 'rrr'], ['bbb', 'ztutrutr'], ['cccc', 'zuzu'], ['ddd']]].
Is there a smart way to access spreadsheet content to avoid quite large list processing.
Thanks.
1 2 3 4 5 6 7 |
from pyexcel_ods3 import save_data from pyexcel_ods3 import get_data path = '/.../test.ods' data_in = get_data(path) rows = data_in.values() for row in rows: print (row) |