pyexcel.save_book_as

pyexcel.save_book_as(**keywords)[source]

Save a book from a data source to another one

Parameters:
  • dest_file_name – another file name. out_file is deprecated though is still accepted.
  • dest_file_type – this is needed if you want to save to memory
  • dest_session – the target database session
  • dest_tables – the list of target destination tables
  • dest_models – the list of target destination django models
  • dest_mapdicts – a list of mapping dictionaries
  • dest_initializers – table initialization functions
  • dest_mapdicts – to nominate a model or table fields. Optional
  • dest_batch_size – batch creation size. Optional
  • keywords – additional keywords can be found at pyexcel.get_book()
Returns:

IO stream if saving to memory. None otherwise

Saving to source parameters
file dest_file_name, dest_sheet_name, keywords with prefix ‘dest’
memory dest_file_type, dest_content, dest_sheet_name, keywords with prefix ‘dest’
sql dest_session, dest_tables, dest_table_init_func, dest_mapdict
django model dest_models, dest_initializers, dest_mapdict, dest_batch_size