Data transfer - data source / destination "OpenOffice Calc Spreadsheet"
Here you will find the instructions for configuring a data transfer if you have selected "OpenOffice Calc Spreadsheet" as the type of data source or type of data target in the first step when creating the connection.
Source / destination - OpenOffice spreadsheet file
Select the file and the time zone here. The file must be stored in a directory that the server has access to.
Click "Next".
OpenOffice spreadsheet settings
Select the table here.
File contains headers
With this setting, the first line is not imported but used as a column title for the field assignment.
Ignore blank lines
Suppresses the import of empty lines.
Cell area
No range
Uses the entire table.
Range specified by coordinates
Enter the number of the first and last column and row, respectively.