I am creating a console application (Scheduler) which triggers emails regularly.
here I want to read an excel file, how to implement this.
step by step solution will be appreciated,
Not understanding how to use the below connection string-
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES";
What I have tried:
this is the article I'm referring to implement this:
https://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-using-ADO.Net-and-C.aspx[
^]