The Data Plug-in allows you to read, write and manipulate Excel spreadsheets into your Servoy solution without needing Microsoft Excel.

Exporting data can be done using a 2D array (arrayname[][]), a dataset or a foundset

The header can be retrieved from the input dataset or set separately via an array. Convenient to 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.

With a so called 'FormattedDataset' you can:

• set cell formatting
• set column formatting
• set borders
• add formula's
• etc.

The Plug-in also implements a function to execute a query on a database/table without the need of an available form. The function uses a server connection created in the Servoy preferences. There is no need however to enable the server.

Additional to reading, writing and updating Excel files you can also you can work with:

• CSV (comma delimited) files
• DBF files
• XML (native) files
• TXT (tab delimited) files

• To script the import of data.
• To script the export of data.
• To import data fast.
• To automatically type cast (convert the import & export) data.

In fact whenever a user needs to import data on a regular basis the Data Plug-in will be a great help.

4.5-059 11/02/2011
[chg] included latest 7.0.1 Aspose libraries

4.5-058 09/13/2011
[new] added getMaxColumnIndex() to FormattedDataSet
[new] added new method (non visible) getJSDataSet(...) to 'repair' backward compatibility of DataSets with Servoy 4
[fix] added getMaxRowIndex() to FormattedDataSet again

4.5-057 09/05/2011
[new] added .xltm, .xlsb, xlsm and .ods file format
[new] it is now possible to save a file as pdf (use .pdf extension)
[chg] included latest 2.5 Aspose libraries
[fix] updating a xlsm sheet now keeps macro's intact

4.3-055 08/22/2011
[chg] extension .xlsm is now respected, retained and treated as xlsx (Excel 2007)

4.3-054 08/13/2011
[chg] removed all deprecated methods
[chg] prefixed all Plug-in objects with ID for JS Documentation in Servoy 6
[chg] made several changes for improved compatibiliby with Servoy 6

4.2-052 07/05/2011
[fix] DBF: all data types are converted to a string value for field with data type String value
[chg] XML: added additional type cast to String value when data type casting fails
[chg] included new changed solution with slightly enhanced samples for writing DBF and XML

4.2-051 06/24/2011
[fix] bypassed an issue in Servoy 5 that caused FormattedDataSet methods to throw an error

4.2-050 05/16/2011
[new] added optional border type to FormattedDataSet.setCellBorder(row,column,[type],border,color) to allow separate setting of each border
[new] added FormattedDataSet.clear() to remove the content of a cell (not the formatting)

4.2-049 03/02/2011
[new] added FormattedDataSet.setFormat(custom format)

4.1-048 12/29/2010
[fix] implemented (forgotten) update method for updating sheets starting at a different position

4.1-046 06/11/2010
[chg] changed libraries to support (backward) compatibility between (beta) releases

4.1-044 05/05/2010
[chg] made several changes to fix security issue with latest Java release
[fix] corrected issue with reading date object from excel sheet

4.1-040 01/29/2010
[new] introduced setSheetName(workbook, index/name, new name)
[new] introduced addSheet(workbook, sheetIndex/sheetName)
[new] introduced removeSheet(workbook, sheetIndex/sheetName)
[new] introduced moveSheet(workbook, oldIndex, newIndex)
[new] introduced cloneSheet(workbook, sheetIndex/sheetName)
[new] getSheetNames now works with fileName (already available) as well as with a workbook (new)
[chg] improved Framework to work with external (gui and command-line) installer
[chg] when writing a datetime cell the format is now automatically set
[fix] corrected issue with writing an array with unknown data types
[fix] corrected issue with writing null cells in xlsx format
[fix] corrected issue with text encoding format
[fix] corrected issue with column width (last colum width was not set)
[fix] corrected issue with sheetNames not used with setting data
[fix] corrected issue with readWorkbook(...) delivering an empty workbook
[fix] corrected issue with writeWorkbook(...) throwing an error

4.0-032 08/17/2009
[chg] deprecated flushClientsCache, use DatabaseManager instead

4.0-031 07/28/2009
[chg] removed signature from core-common.jar to avoid security issues

4.0-030 03/16/2009
[chg] it is not longer necessary to register a developer license

4.0-029 01/19/2009
[chg] made some adjustments to core activation wizard

4.0-027 12/05/2008
[fix] it is now possible to write a correct .xlsx file

4.0-027 12/05/2008
[fix] corrected license issue

4.0-026 10/30/2008
[chg] improved license feedback in log file
[fix] corrected issue with formatted cell background not used correct
[fix] corrected issue with writing xlxs file
[fix] changed a couple of core functions

4.0-025 10/30/2008
[fix] corrected issue with client not finding libraries.

4.0-024 10/22/2008
[fix] preference panel 'Components' is now available again

4.0-023 10/21/2008
[new] output is now also possible in xlxs format
[new] added createUserColor method to change a user color to be used for setting colors
[bug] output to xlxs format could cause an issue
[fix] corrected issue with Eclipse update manager

3.4-020 08/16/2008
[fix] corrected startup file for client loaded from application server

3.4-019 06/30/2008
[chg] redesigned for Servoy 4.0

3.3-018 04/22/2008
[chg] made some important improvements to the core to prepare for Servoy 4.0

3.3-016 02/25/2008
[new] added method 'getVersionLicensed' to find out what version is licensed
[chg] reading a date formatted cell now returns Date Object instead of double
[chg] reduced client download size for resources with overall savings up to 45%
[fix] writing a new file with overwrite = false (default) now does not write 2 files anymore

3.3-015 12/19/2007
[chg] improved sample code to adopt some changes

3.3-014 09/19/2007
[new] added createFont() method to FormattedDataSet
[fix] removed debugging output from dataset
[chg] added more font samples to sample solution

3.3-013
[fix] solved an issue with reading and typecasting excel sheet cells
3.3-012

[fix] excel().writeArray(...) writes header again

3.3-011
[chg] went back to older version of apache-poi
[chg] corrected FormattedDataSet.addRow(index, array) to accept an index beyond rowCount

3.3-010
[new] introduced ExcelColor class with 48 predefined color codes
[chg] added latest version of apache-poi
[bug] when you use custom colors only the first defined color will be used

3.3-009
[fix] corrected bug in 'setValue(..)' method of FormattedDataSet

3.3-008
[new] added 'addRow(..)' method to FormattedDataSet
[new] added 'removeRow(..)' method to FormattedDataSet
[new] added 'setRow(..)' method to FormattedDataSet
[new] added 'getColumnName(...)' method to FormattedDataSet
[new] added 'setValue(..)' method to FormattedDataSet
[new] added 'getValue(...)' method to FormattedDataSet
[new] added 'setCellFormula(..)' method to FormattedDataSet
[chg] added setCellFormula to sample solution
[chg] the write method for an excel sheet does not accept a JSFile anymore (should be an absolutePath)

3.3-007
[new] added 'quote' property to write TXT files
[new] added FormattedDataSet to write Excel files
[chg] added FormattedDataSet sample to sample solution
[fix] tooltips in classes are available again

3.1-007
[chg] improved feedback about missing data libraries
[chg] it is now possible to create a really empty row ['']

3.1-006
[new] case 0000099: added setSheetName(String sheetname) to add a sheetName to a sheet
[new] added getVersion() and getLicense() methods to retrieve component information
[chg] the Plug-in is now lazy loading (again)
[chg] updated sample solution to show writeArray intstead of write method for writing an Array

3.0-004
[new] case 0000023: added new WorkBook write/read options to Excel class to update an existing sheet without losing formatting, functions etc.

3.0-003
[chg] added the plug-in to the new Update manager
[fix] fixed issue with using sheets
[fix] fixed issue that did not return the correct column count after reading an xml
[fix] fixed issue where empty values were not returned after reading an xml
[fix] modified latest excel libraries so that they now also work with Servoy 2.x.x
[new] added writeHeader property to CSV class to enable or disable writing of the header

3.0
[new] added option to update an existing excel sheet

2.0.1
[fix] corrected a bug that prevented the plug-in from registering a second time
[enh] dialog feedback when license data is wrong
[fix] fixed issue with update checker on windows platform

2.0
[new] added QuickBooks contact import and export
[new] added functions to filter a DataSet
[new] added encoding to read .csv and .txt files
[enh] added new sample code to sample solution

1.2
[opt] optimized some of the code
[bug] fixed a bug where the excel import stopped importing when a cell was empty
[fix] corrected sample code

1.1
[new] added TXT (tab delimited) file support.
[enh] added separator property to csv file support.
[new] added sample solution
[enh] improved sample code in plug-in

1.0
[new] initial