to access the same cellwe can use this linesheet row[" "][ for the same reasonthe row index has been reduced by since we have named columns and rowsit is possible to access the same cell like thisprint(sheet[" "" "] sheet[" "" " print(sheet[" "" "] notewhen you have named your rows and columnsin order to set value to cellplease use sheet[row_namecolumn_namenew_value for multiple sheet fileyou can regard it as three dimensional array if you use book soyou access each cell via this syntaxbook[sheet_index][rowcolumnorbook["sheet_name"][rowcolumnsuppose you have the following sheetsand you can randomly access cell in sheetbook pyexcel get_book(file_name="example xls"print(book["sheet "][ , ] print(book[ ][ , ]the same cell tipwith pyexcelyou can regard single sheet reader as an two dimensional array and multi-sheet excel book reader as ordered dictionary of two dimensional arrays reading single sheet excel file suppose you have csvxlsxlsx file as the followingthe following code will give you the data in jsonimport json "example csv","example xlsx","example xlsmsheet pyexcel get_sheet(file_name="example xls"print(json dumps(sheet to_array())[[ ][ ][ ] old tutorial