score:0

add references remotion.data.linq.dll. you can find it in nuget;

https://staging.nuget.org/packages/remotion.data.linq/

score:0

i think the documentation for using linqtoexcel is not good.

i have used below code.

        string filename = @"youpath";
        string conn = string.empty;
        datatable dtexcel = new datatable();
        conn = @"provider=microsoft.ace.oledb.12.0;data source=" + filename 
        + ";extended properties='excel 12.0;hdr=no';"; //for above excel 
        2007 

        using (oledbconnection con = new oledbconnection(conn))
        {
            con.open();
            datatable sheets = 
            con.getoledbschematable(oledbschemaguid.tables, null);

            try
            {
                oledbdataadapter oleadpt = new oledbdataadapter("select * 
                from [worksheetname$]", con); //here we read data from 
                sheet1  
                oleadpt.fill(dtexcel); //fill excel data into datatable  
            }
            catch (exception ex)
            {
            }
        }
        return dtexcel;

Related Query

More Query from same tag