.NET odsReader for OpenDocument Spreadsheet 1.0 (Build 1.0.0.0) Readme

© 2012 xPortTools Inc. All rights reserved.


Welcome to the release of the .NET odsReader for OpenDocument Spreadsheet Release. This readme file contains important information about this release of product.

Software Requirements

.NET Framework 2.0 Version 2.0.50727 or newer

Visual Studio .NET 2005 or newer

Windows 2000 or newer

Installation Instructions

For the installation of the .NET odsReader for OpenDocument Spreadsheet 2.0 you are required to install .NET Framework 2.0 or newer. To install .NET odsReader for OpenDocument Spreadsheet run Setup.exe and follow installation wizard prompts.

IMPORTANT: To install component under Windows Vista or Windows 7 you need to select Setup.exe file, right click on it and select "Run as Administrator" option in popup menu.

What is .NET odsReader for OpenDocument Spreadsheet

.NET odsReader for OpenDocument Spreadsheet is a set of the classes, designed to help .NET developers to read OpenDocument Spreadsheet files from their applications. To provide familiar feel and look for the developers and allow future extension of the component, current version of the .NET odsReader for OpenDocument Spreadsheet implemented as a .NET Managed Provider with the read-only capabilities and allows to read the data from the native OpenDocument Spreadsheet files without using any additional providers. .NET odsReader for OpenDocument Spreadsheet is a 100% .NET managed code and designed to achieve the best performance with the minimal usage of the RAM.

Known issues and limitations

Current version of the .NET odsReader for OpenDocument Spreadsheet has several limitations on how it works and what it supports during reading of the data from OpenDocument Spreadsheet files. Future versions of the component could contain functionality to resolve current limitations. Current limitations are:

   - No support for password-protected OpenDocument Spreadsheet files.

   - .NET odsReader for OpenDocument Spreadsheet supports only files saved in a ODS/OTS formats supported by OpenOffice.org Calc, LibreOffice Calc or any other application that supports ODS/OTS file formats.

   - Limited support for the SQL statements. Current version of the reader supports only delimited list of the spreadsheet names in following format: "shreadsheetname1;spreadsheet2;.... spreadsheetN;" and treats each spreadsheet as a table. List of the spreadsheet names should contain at least one spreadsheet name. See more details inside of examples on how to query data from the spreadsheets.

   - Component does not support updates of the data from the DataTable/DataSet to the underlying OpenDocument Spreadsheet file. OdsDataAdapter allows populating DataTable/DataSet with the data from the spreadsheet(s), but current version does not support updates.

Sample application/Documentation

Installation of the .NET odsReader for OpenDocument Spreadsheet contains sample Visual Basic .NET and C# applications that covers all the generic situations how developers could use the component in their development environment. Installation also integrates full documentation into your development Visual Studio .NET help collection. If you have any questions regarding using of the component or submit a bug, you could visit http://www.xporttools.net/support.aspx and submit your request online.