transpose(vertical(table continued from previous page rotate the data table by degrees default iterator to go through each cell one by one from leftmost column to rightmost row and from top to bottom example attributes array bookdict csv csvz dict fods matrix grid handsontable handsontable_html html matrix json matrix latex matrix latex_booktabs matrix mediawiki matrix ndjson ods matrix orgtbl matrix pipe matrix plain records matrix rst matrix simple stream svg texttable tsv tsvz url xls xlsm xlsx sheetstream(namepayloadbookstream([sheetsfilenamepath]get/set data in/from array format get/set data in/from bookdict format get/set data in/from csv format get/set data in/from csvz format get/set data in/from dict format set data in fods format get data in handsontable format get data in handsontable html format set data in html format get/set data in/from ods format get/set data in/from records format return stream in which the content is properly encoded get data in svg format get data in texttable format get/set data in/from tsv format get/set data in/from tsvz format set data in url format get/set data in/from xls format get/set data in/from xlsm format get/set data in/from xlsx format memory efficient sheet representation memory efficient book representation pyexcel internal generators sheetstream class pyexcel internal generators sheetstream(namepayloadmemory efficient sheet representation this class wraps around the data read from pyexcel-io comparing with pyexcel sheetthe instance of this class does not load all data into memory hence it performs better when dealing with big data api documentation