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