Description

.NET xlReader for Microsoft® Excel is a set of the classes, designed to read XLS, XLT, XLSX, XLTX and XLTM Microsoft® Excel files from .NET applications. To provide familiar feel and look for the developers and allow future extension of the component, current version of the .NET xlReader for Microsoft® Excel implemented as a .NET Managed Provider with the read-only capabilities and allows to read the data from the native Microsoft® Excel files without using any additional providers or Microsoft® Excel. .NET xlReader for Microsoft® Excel is a 100% .NET managed code and designed to achieve the best performance with the minimal usage of the RAM.

Syntax Example

C# Sample code //Sample code retrieves data and populates DataSet from two spreadsheets //inside of Excel file. ExcelDataAdapter excelAdapter; DataSet result; string format = cmbFormat.SelectedItem.ToString(); string pathToFile = "..\\..\\AuthorsInfo.xlsx"; try { //Create an ExceldataAdapter to retrieve data into the DataSet. //Overloaded constructor accepts query and connection string. //Specify that first row in a spreadsheet is a header row (HDR=true) excelAdapter = new ExcelDataAdapter("Authors;Titles", "Data Source=" + pathToFile + ";HDR=true;Format=" + format); result = new DataSet(); //Get data from the file excelAdapter.Fill(result); //Do something with the DataTables here dataGridView1.DataSource = result.Tables[0]; dataGridView2.DataSource = result.Tables[1]; //Release all the opened resources excelAdapter.Dispose(); excelAdapter = null; -------------------- VB.NET Sample Code 'Sample code retrieves data and populates DataSet from two spreadsheets 'inside of Excel file. Dim excelAdapter As ExcelDataAdapter Dim result As DataSet Dim format As String = cmbFormat.SelectedItem.ToString() Dim pathToFile As String = "..\AuthorsInfo.xlsx" Try 'Create an ExceldataAdapter to retrieve data into the DataSet. 'Overloaded constructor accepts query and connection string. 'Specify that first row in a spreadsheet is a header row (HDR=true) excelAdapter = New ExcelDataAdapter("Authors;Titles", "Data Source=" & pathToFile & ";HDR=true;Format=" & format) result = New DataSet() 'Get data from the file excelAdapter.Fill(result) 'Do something with the DataTables here dataGridView1.DataSource = result.Tables(0) dataGridView2.DataSource = result.Tables(1) 'Release all the opened resources excelAdapter.Dispose() excelAdapter = Nothing Catch ex As Exception MessageBox.Show(ex.Message) End Try

Reviews

Submit a review