sheetdata manipulation the data in sheet is represented by sheet which maintains the data as list of lists you can regard sheet as two dimensional array with additional iterators random access to individual column and row is exposed by column and row column manipulation suppose have one data file as the followingsheet pyexcel get_sheet(file_name="example xls"name_columns_by_row= sheet pyexcel sheet+++column column column +==========+==========+========== +++ +++ +++and you want to update column with these data[ sheet column["column "[ sheet column[ [ sheet pyexcel sheet+++column column column +==========+==========+========== +++ +++ +++remove one column of data file if you want to remove column you can just calldel sheet column["column "sheet column["column "[ the sheet content will becomesheet pyexcel sheet++column column +==========+==========(continues on next page old tutorial