The Data Plugin enables you to read, write and manipulate MS Excel® workbooks and sheets from within your Servoy solution without the need to have MS Excel® installed.
Exporting data can be done using a 2D array (vArray), a dataset or a foundset
The header can be retrieved from the input dataset or set separately via an array so you can create logical headers to the user or use i18n headers.
Importing data returns a 2D array or a (again) a regular dataset.
When using the readWorkBook and writeWorkBook methods it is possible to read and write a single cell, without touching/removing the available formatting and functions.
Since version 3.3 it is also possible to create a new Excel sheet with formatting properties.
To enable adding formatting options and functions we created a formatted dataset based on a ‘normal’ dataset.
With a the called ‘FormattedDataset’ you can:
- set cell formatting
- set column formatting
- set borders
- add formula’s