.NET odsReader for OpenDocument Spreadsheet
This .NET Framework Class Library is provided by xPortTools.
The main functionality of the class library is contained in the file xPortTools.OdsClient.dll.
Add a reference to the assembly xPortTools.OdsClient and include the xPortTools.OdsClient namespace. Instantiate a new OdsConnection connection object. Set the connection string and open the connection.
VB.NET code sample
Imports xPortTools.OdsClient
Dim myConnection As OdsConnection = New OdsConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()C# code sample
using xPortTools.OdsClient;
OdsConnection myConnection = new OdsConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();Description
.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.
There are some limitations with this provider...
- No support for password-protected OpenDocument Spreadsheet files.
- 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.
More info about this class library can be found at the xPortTools product page.
Download
This .NET Framework Class Library, .NET odsReader for OpenDocument Spreadsheet, can be downloaded here.
Connection Strings
The .NET odsReader for OpenDocument Spreadsheet class library can be used to connect to the following data sources by using the following connection string references: