Excel2DB

Database::Excel2DB

Description

Save the contents of an Excel worksheet to a recordset handle.

The data of the worksheet can be processed in two different ways: "Export Sheet to Handle" and "Export Sheet to Pivot Handle"

Export Sheet to Handle

straightforward export of the sheet data to a recordset without any special processing

Export Sheet to Pivot Handle

special "pivot" handling of the data. The recorset will contain the following columns in which the data will be saved:

Xaxis, Yaxis, CellValue, Filename, CreationDate

Options

Excel file

The Excel workbook file.

Sheet Name

The Excel worksheet name. If left empty the default sheet will be used.

Function

The export-function to use.

Output Handle

The name of the output recordset.

Skip first row

If enabled, the first row of the worksheet will not be included in the export.

Use row 'n' for column names

If enabled, the data of the configured row will be used for the column names. If disabled, the columns will be named "Col1", "Col2", etc...

Insert NULL when value is empty

If enabled, a NULL value will be inserted into the recordset whenever a cell is empty. If disabled, an empty string will be inserted.

SetConnect

Excel2DB

Documentation