How to read data from an excel file with C# using Excel Data Reader
Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.IO;
using ExcelDataReader;
using System.Data;
namespace readExcelReader
{
internal class Program
{
static void Main(string[] args)
{
var filepath = @"C:\Users\AZHAR PC\Desktop\Excel\writeDataFile.xlsx";
System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance);
using (var streamval = File.Open(filepath, FileMode.Open, FileAccess.Read))
{
using (var reader = ExcelReaderFactory.CreateReader(streamval))
{
var configuration = new ExcelDataSetConfiguration
{
ConfigureDataTable = _ = new ExcelDataTableConfiguration
{
UseHeaderRow = false
}
};
var dataSet = reader.AsDataSet(configuration);
if (dataSet.Tables.Count 0)
{
var dataTable = dataSet.Tables[0];
Console.WriteLine("Rows : " + dataTable.Rows.Count);
Console.WriteLine("Columns : " + dataTable.Columns.Count);
}
else
{
Console.WriteLine("Sheet doesn't exist");
}
}
}
}
}
}
Chapters:
0:00 - Introduction to the video
1:11 - Procedure to read data from excel by excel data reader
8:41 - End Tags and Subscription to the channel
My second Channel:
WrestleTalkByAzhar - / wrestletalkbyazhar
Follow Insta:
/ kingazharjamal
/ fari_digi
Next Steps :
---------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------
Must Watch Playlists
► 1. Javascript - • Javascript Factory
► 2. Puppetter - • Puppeteer
► 3. Cypress - • Cypress
► 4. Tech works - • Video
► 5. Vbscript Basics To Advanced - • VBScript Part 1 - Fea...
► 6. Jmeter - • Jmeter Tutorials
► 7. Excel - • Videos On Excel
► 8. Appium - • Appium
► 9. Shares - • Shares
► 10. Javascript Interview Questions - • Javascript Interview Q...
► 11. C# Tutorials - • C# Factory
► 12. HTML & CSS - • HTML & CSS
► 13. Browser Console - • Browser Console
► 14. JSON - • Videos on Json
► 15. Specflow - • Specflow Tutorials
► 16. MongoDB - • MongoDB Tutorials
► 17. Postman - • Postman
► 18. Python - • Python
---------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------
#excel
#csharp
#csharptutorial