Reading Excel binary file from c# code (.xlsb)

Question

Hi All Can anyone help regarding how to read an Excel binary file (.xlsb) spread sheet from c# code and using DocumentFormat.OpenXml Thank you in Advance

prasanta pradhan · Answer

Hi.. string strPath = Request.PhysicalApplicationPath + @document\abc.xls; object file = strPath; //Microsoft.Office.Interop.Excel.Application app; app = new Microsoft.Office.Interop.Excel.Application(); workBook = app.Workbooks.Open(strPath 0true5trueMicrosoft.Office.Interop.Excel.XlPlatform.xlWindows 	 falsefalse0true10); int SheetCount = workBook.Sheets.Count; object index = 0; object rowIndex = 1; object colIndex1 = 1; object colIndex2 = 2; string strsearch = pratap; int rcount ccount; Microsoft.Office.Interop.Excel.Range rng1; workSheet =(Microsoft.Office.Interop.Excel.Worksheet) workBook.ActiveSheet; rowIndex = workSheet.Rows.Count; colIndex1 = workSheet.Columns.Count; rcount = workSheet.Rows.Count; ccount = workSheet.Columns.Count; for (int j = 0; j { for (int k = 0; k { rng1=((Microsoft.Office.Interop.Excel.Range)workSheet.Cells[rowIndex colIndex1]); if (rng1.Text.ToString().Trim().ToLower() == strsearch.ToLower()) rng1.Cells.Interior.ColorIndex = 6; } } } workBook.Save(); app.Quit(); } Thank's Prasanta Kumar Pradhan http://globaltouch.in