ExcelTable

With the ExcelTable table component, you can manipulate any Excel sheet. This ExcelTable component is an example of an Automation Server, NOT a J2EE component.

In the Constructor SQL statement on the State tab page, you specify the Excel document, the default sheet name, the offset cel where the table starts (normally A1), and the numbers of colums belonging to the PK.

The Component starts initially with a primary key column called ID and an additional 20 columns KOLOM1 .. 20. But you are free to add or remove these columns.

For more information, refer to the internal description of the component.