pyexcel.get_book

pyexcel.get_book(**keywords)[source]

Get an instance of Book from an excel source

Parameters:
  • file_name – a file with supported file extension
  • file_content – the file content
  • file_stream – the file stream
  • file_type – the file type in content
  • session – database session
  • tables – a list of database table
  • models – a list of django models
  • bookdict – a dictionary of two dimensional arrays
  • url – a download http url for your excel file

see also A list of supported data structures

Here is a table of parameters:

source parameters
loading from file file_name, keywords
loading from memory file_type, content, keywords
loading from sql session, tables
loading from django models models
loading from dictionary bookdict
loading from an url url

Where the dictionary should have text as keys and two dimensional array as values.