api documentation api reference this is intended for users of pyexcel signature functions obtaining data from excel file get_array(**keywordsget_dict([name_columns_by_row]get_records([name_columns_by_row]get_book_dict(**keywordsget_book(**keywordsget_sheet(**keywordsiget_book(**keywordsiget_array(**keywordsiget_records([custom_headers]free_resources(obtain an array from an excel source obtain dictionary from an excel source obtain list of records from an excel source obtain dictionary of two dimensional arrays get an instance of book from an excel source get an instance of sheet from an excel source get an instance of bookstream from an excel source obtain generator of an two dimensional array from an excel source obtain generator of list of records from an excel source close file handles opened by signature functions that starts with 'ipyexcel get_array pyexcel get_array(**keywordsobtain an array from an excel source it accepts the same parameters as get_sheet(but return an array instead not all parameters are needed here is table source loading from file loading from string loading from stream loading from sql loading from sql in django loading from query sets loading from dictionary loading from records loading from array loading from an url parameters file_namesheet_namekeywords file_contentfile_typesheet_namekeywords file_streamfile_typesheet_namekeywords sessiontable model any query sets(sqlalchemy or djangoadictwith_keys records array url parameters file_name file with supported file extension file_content the file content file_stream the file stream support the project