Read from XLS file to table in .NET using C# – this tutorial shows reading Excel files in .NET with Spreadsheet SDK. Use source code sample below to read data from XLS file in CSharp.


 const string inputFile = @"PeriodicTableOfElementsSpreadsheet.xls";

           // Create new spreadsheet to read xls to table in .net
           Spreadsheet spreadsheet = new Spreadsheet();

           // Read XLS to table using Spreadsheet SDK
           DataTable dt = spreadsheet.ExportToDataTable();

           // Close spreadsheet object