.xlsx read without installed ms office on server

Question

.xlsx read without installed ms office2007 on server. any other way to read xlsx file without office driver

Neboja · Answer

Hi Digamber here is another way you can try just add this .NET DLL for workbooks (Excel files) . It is pretty easy to use it for example here is how you would read excel workbooks in C# code behind : // Load Excel file. var workbook = ExcelFile .Load(excelStream LoadOptions .XlsxDefault); // Select active worksheet. var worksheet = workbook.Worksheets.ActiveWorksheet; // Retrieve the value of first cell. var value = worksheet.Cells[ A1 ].Value;

Suthish Nair · Answer

Ok you are missing Office data providers Download from here and install the drivers..

Digamber Patil · Answer

I get the following error :--- The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Suthish Nair · Answer

using System.Data.OleDb; using (OleDbConnection obj = new OleDbConnection()) { obj.ConnectionString = ---; obj.Open(); using (DataTable dt = obj.GetOleDbSchemaTable(OleDbSchemaGuid.Tables null)) { } } http://www.connectionstrings.com/excel

Digamber Patil · Answer

Which Dll or driver need to be download for OLEDB (MY config is Win7 Enterprise ASP.net 3.5 )

Suthish Nair · Answer

http://www.c-sharpcorner.com/Blogs/5253/how-to-read-excel-data-in-Asp-Net.aspx Inserting & Retrieving records from M.S.Excel-2007 using oledb in C#.net http://www.c-sharpcorner.com/UploadFile/e628d9/4038/

Digamber Patil · Answer

Yes but How. Can you give me a sample code for that so i can implement that one.

Suthish Nair · Answer

using oledb...