The Data Plug-in adds more flexible import and export possibilities to Servoy via scripting.

With this version of the Plug-in you can work with:

• CSV (comma delimited) files
• DBF files
• XML (native) files
• TXT (tab delimited) files
• QuickBooks contacts
• Excel files (update and new)
• 
  

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

The header can be retrieved from the input dataset or set seperately 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.

It is not only possible to read and write an Excel sheet as an array of data but it is also possible to update an Excel sheet.
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 (limited) formatting properties.

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.

• 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.1-048 07/14/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