.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...

.xlsx read without installed ms office on server

Answers (8)