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

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:

Read data to data table:

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Leon D4y ago
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 <= maxRow; row++)
            {
                for (int col = 1; col <= maxColumn; col++)
                {

                    Console.Write(sheet[row, col].Value);
                    Console.Write("\t");
                }
                Console.Write("\n");
            }

            Console.ReadKey();
        }
    }
}
Read data to data table:
Workbook workbook = new Workbook();
workbook.LoadFromFile("Input.xls");
Worksheet sheet = workbook.Worksheets[0];

DataTable dt = sheet.ExportDataTable();
+1
Pravat Kumar4y ago
Thank you @sachin singh for quick response.

I want to read XLS file.
+1
Sachin Singh4y ago
you can follow this straight forward example

https://www.csharp-console-examples.com/general/reading-excel-file-in-c-console-application/
+1