Import Cells from xlsx
(version 6.0.2)
Get a metadata from db table
Read the table structure from database and prepare the metadata for import
Syntax:
Argument | Description |
datasourceId | optional parameter (can be null); it defines the additional datastore to use |
tableName | table name |
Update the table metadata
Update the table metadata if the table structure are changed
Syntax:
Argument | Description |
dbTableId | id of table metadata |
Create value for imports
This function create the metadata for import. Prepare the data from table and read the xlsx file for values.
Syntax:
Argument | Description |
dbTableId | id of table metadata for import |
directoryId | id of the directory where to search the file |
fileName | file name |
description | description for import (can be null) |
note | note for import (can be null) |
inputData | string in json format for data in import (can be null) |
breakOnColumnsEmpty | number of empty cells in row to stop reading values in the sheet (default 5) (can be null) |
breakOnRowsEmpty | number of empty rows to stop reading values in the sheet (default 5) (can be null) |
Duplicate value import
This function duplicate the import metadata and read the values from the old file or from the new file.
Syntax:
Argument | Description |
valueImportId | id of import to duplicate |
directoryId | id of the directory where to search the file; can bel null if you want read the old file |
fileName | file name; can bel null if you want read the old file |
description | description for import (can be null) |
note | note for import (can be null) |
inputData | string in json format for data in import (can be null) |
breakOnColumnsEmpty | number of empty cells in row to stop reading values in the sheet (default 5) (can be null) |
breakOnRowsEmpty | number of empty rows to stop reading values in the sheet (default 5) (can be null) |
ignoreSheet | ignore the deleted sheet and remove the references |
Import Cells from Excel File
This function import the mapped cells value from excel into the database table.
Syntax:
Argument | Description |
valueImportId | id of import to duplicate |
directoryId | id of the directory where to search the file |
fileName | file name |
valueImportId | id of defined import |
fieldsData | other value of fields table to valorize in import |
inputData | string in json format for data in import (can be null) |
separatedTransaction | flag true|false indicating whether the SQL query must be executed in a separated database transaction or within the current one |
Check cells from excel file
This function check the mapped cells from excel and verify the mandatory values, the format etc
Syntax:
Argument | Description |
valueImportId | id of import to duplicate |
directoryId | id of the directory where to search the file |
fileName | file name |
valueImportId | id of defined import |
Export areas from excel to new file excel
This function copies the cells value of an area to the specified area in a new file
Syntax:
Argument | Description |
sourceDirId | id of the source file directory |
sourceFileName | source file name (xlsx) |
destDirId | id of the destination file directory |
destFileName | destination file name (xlsx) |
areas | list of cells area to export |
Example
Export areas from excel to Google Spreadsheet
This function copies the cells value of an area to the specified area in a Google Spreadsheet
Syntax:
Argument | Description |
sourceDirId | id of the source file directory |
sourceFileName | source file name (xlsx) |
spreadsheetId | id of the Google Spreadsheet |
areas | list of cells area to export |
Example
Disable Import
This function logically disables an import definition
Syntax:
Argument | Description |
valueImportId | id of the import definition |
Delete Import
This function definitively cancels an import
Syntax:
Argument | Description |
valueImportId | id of the import definition |
Last updated