pyexcel.Sheet.save_to_database

Sheet.save_to_database(session, table, initializer=None, mapdict=None, auto_commit=True)[source]

Save data in sheet to database table

Parameters:
  • session – database session
  • table – a database table or a tuple of (table, initializer, mapdict, name_columns_by_row, name_rows_by_column). initializer is needed when the supplied table had a custom initialization function. mapdict is needed when the column headers of your sheet does not match the column names of the supplied table. name_column_by_row indicates which row has column headers and by default it is the first row of the supplied sheet