pyexcel get_book_dict pyexcel get_book_dict(**keywordsobtain dictionary of two dimensional arrays it accepts the same parameters as get_book(but return dictionary instead here is table of parameterssource loading from file loading from string loading from stream loading from sql loading from django models loading from dictionary loading from an url parameters file_namekeywords file_contentfile_typekeywords file_streamfile_typekeywords sessiontables models bookdict url where the dictionary should have text as keys and two dimensional array as values parameters file_name file with supported file extension file_content the file content file_stream the file stream file_type the file type in file_content or file_stream session database session tables list of database table models list of django models bookdict dictionary of two dimensional arrays url download http url for your excel file sheetsa list of mixed sheet names and sheet indices to be read this is done to keep pandas compactibility with this parametermore than one sheet can be read and you have the control to read the sheets of your interest instead of all available sheets auto_detect_float defaults to true auto_detect_int defaults to true auto_detect_datetime defaults to true ignore_infinity defaults to true library choose specific pyexcel-io plugin for reading source_library choose specific data source plugin for reading parser_library choose pyexcel parser plugin for reading skip_hidden_sheetsdefault is true please toggle it to read hidden sheets parameters related to csv file format for csvfmtparams are accepted delimiter field separator api documentation