(continued from previous pageb+--- +---__init__(sheet=nonename='pyexcel sheet'name_columns_by_row=- name_rows_by_column= colnames=nonerownames=nonetranspose_before=falsetranspose_after=falseconstructor parameters sheet two dimensional array name this becomes the sheet name name_columns_by_row use row to name all columns name_rows_by_column use column to name all rows colnames use an external list of strings to name the columns rownames use an external list of strings to name the rows methods __init__([sheetnamename_columns_by_row]cell_value(rowcolumn[new_value]clone(column_at(indexcolumn_range(columns(contains(predicatecut(topleft_cornerbottomright_cornerdelete_columns(column_indicesdelete_named_column_at(namedelete_named_row_at(namedelete_rows(row_indicesenumerate(extend_columns(columnsextend_columns_with_rows(rowsextend_rows(rowsfilter([column_indicesrow_indices]format(formatterget_array(**keywordsget_bookdict(**keywordsget_csv(**keywordsget_csvz(**keywordsget_dict(**keywordsget_fods(**__sheet get_grid constructor random access to table cells gets the data at the specified column utility function to get column range returns left to right column iterator has something in the table get rectangle shaped data out and clear them in position delete one or more columns works only after you named columns by row take the first column as row names delete one or more rows iterate cell by cell from top to bottom and from left to right take ordereddict to extend named columns put rows on the right most side of the data take ordereddict to extend named rows apply the filter with immediate effect apply formatting action for the whole sheet get data in array format get data in bookdict format get data in csv format get data in csvz format get data in dict format fods getter is not defined continued on next page api documentation