.NET component
Read / View Excel files XLSX XLS CSV

Excel Reader .NET

• File formats: Excel Spreadsheet XLSX, XLS, CSV.
• 100% managed .NET component.
• Doesn't require Microsoft Excel.
• High performance (~50000 records per second).
• Plain & Fair licensing.
• Royalty-Free. No extra cost for Server license.
• 6 Months: Free Support + Free Updates.
Evaluation Version
Download  |   Online Demo
Developer License - $95
Buy now  |   Price List

Skip Navigation LinksUser Experience > Export to DataTable

Excel Reader .NET component



Learning Resources




News & Releases

May 20, 2016
Version 3.1 Update
Excel Reader .NET component
January 24, 2016
Version 3.1 Update
Excel Reader .NET component
April 30, 2013
Version 3.1 Update
Excel Reader .NET component
December 09, 2012
Version 3.1 Update
Excel Reader .NET component
August 13, 2012
Version 3.1 Update
Excel Reader .NET component
June 08, 2012
Version 3.1 New Release!
Excel Reader .NET component
March 15, 2012
Version 2.8 Update
Excel Reader .NET component

Export to DataTable

"How can I export Excel file to DataGrid form component?"
Joseph Smith

Excel Reader .NET presents you an easy way to Export Excel to DataTable.
DataTable can be used as a data source of DataGrid in order to show Excel data.

  1. private void cmdLoad_Click(object sender, EventArgs e)
  2. {
  3.     openFileDialog1.Filter = "Excel files (*.xlsx,*.csv)|*.xlsx;";
  4.     
  5.     // Choose Excel file in Open dialog
  6.     if (openFileDialog1.ShowDialog() == DialogResult.OK)
  7.     {
  8.         // Open Excel File
  9.         string FileName = openFileDialog1.FileName;
  10.         string Extension = Path.GetExtension(FileName);
  11.         ExcelWorkbook Wbook = ExcelWorkbook.ReadXLSX(FileName);
  12.  
  13.         // Show the first sheet of Excel file
  14.         dataGridView1.DataSource = Wbook.Worksheets[0].WriteToDataTable();
  15.     }
  16. }