Import / Export utilities

Utilities for importing or exporting in xlsx format, using openpyxl.

xlsx2sqlite.import_export module

Utilities for importing or exporting xlsx files.

The export_worksheet() function creates a xlsx file with a worksheet containing table data, it uses the openpyxl package.

The import_worksheets() function is useful for importing specified worksheets from a xlsx file, it uses the openpyxl package.

xlsx2sqlite.import_export.export_worksheet(filename=None, ws_name=None, rows=None)

Export data as a xlsx worksheet file.

Key filename

Full path of the xlsx file to be saved.

Key ws_name

Name of the worksheet.

Key rows

Iterable containing rows data to append to the worksheet.

xlsx2sqlite.import_export.import_worksheet(workbook=None, worksheet=None)

Import worksheet from a workbook using openpyxl.

Key workbook

Name of the xlsx file to open read only.

Key worksheet

Names of the worksheet to import.

Returns

A representation of a table with data from the imported worksheet.