How read .XLS file content in my .NetCore console application?

Question

Leon D · Answer

You can install Spire.XLS via NuGet and then use it to read xls or xlsx files easily. http://nuget.org/packages/Spire.XLS/ Read data by looping through cells: using Spire.Xls; using Spire.Xls.Collections; using System; using System.Collections.Generic; using System.Data; using System.Drawing; using System.IO; using System.Text; namespace ReadExcelFiles { class Program { static void Main( string [] args) { Workbook workbook = new Workbook(); workbook.LoadFromFile( "Input.xls" ); Worksheet sheet = workbook.Worksheets[0]; int maxRow = sheet.LastRow; int maxColumn = sheet.LastColumn; for ( int row = 1; row { for ( int col = 1; col { Console.Write(sheet[row, col].Value); Console.Write( "	" ); } Console.Write( "
" ); } Console.ReadKey(); } } } Read data to data table: Workbook workbook = new Workbook(); workbook.LoadFromFile( "Input.xls" ); Worksheet sheet = workbook.Worksheets[0]; DataTable dt = sheet.ExportDataTable();

Pravat Kumar · Answer

Thank you @sachin singh for quick response. I want to read XLS file.

Sachin Singh · Answer

you can follow this straight forward example https://www.csharp-console-examples.com/general/reading-excel-file-in-c-console-application/

How read .XLS file content in my .NetCore console application?

Answers (3)