Reading data from Excel sheet using LINQ

Question

hi to all
can anyone plz help how to read data from excel sheet using ling in c# console application
thanks

vinay wagarkar · Answer

you will get usefull information by this link https://msdn.microsoft.com/en-us/library/dd920313(v=office.12).aspx

srinivas · Answer

thanks for your help
but in first link they are  taking  data from a table in excel sheet
in second link they are not using linq
when i enter the data into a new excel sheet then it should create a table with the given column names
how to create a table in excel sheet and column names
plz help

Lalit M · Answer

hi,Srinivas
you will get information from this link
http://msdn.microsoft.com/en-us/library/dd920313.aspx
http://sandeep-aparajit.blogspot.com/2008/08/how-to-read-excel-in-c.html