paulyoder / LinqToExcel

Use LINQ to retrieve data from spreadsheets and csv files
MIT License
1.06k stars 299 forks source link

not working with office 365 pro plus #116

Closed mail2soumenpal closed 7 years ago

mail2soumenpal commented 7 years ago

office 365 pro plus is installed in my system, whenever i am trying to use the below code, it throws error - string pathToExcelFile = "" + @"D:\Book1.xlsx";

        string sheetName = "Sheet1";

        var excelFile = new ExcelQueryFactory(pathToExcelFile);
        var getData = from a in excelFile.Worksheet(sheetName) select a;
        string getInfo = String.Empty;

        foreach (var a in getData)
        {
            getInfo += "Name: " + a["Name"] + "; Phone: " + a["Phone"] + ">>   ";

        }
        textBox1.Text = getInfo;

please return back with solution ASAP its urgent. I am using latest version of linqtosql from nuget error

unickq commented 7 years ago

Same issue here The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'

mrworkman commented 7 years ago

You need to install the Microsoft Access Database Engine - either the 32bit, or the 64bit version, depending on your project settings.