How to import Excel with Password proteced file to Datagrid

Question

How to import the Excel file with Password proteced file to my wpf Datagrid. plz give me the source codes

Suvendu Shekhar Giri · Answer

plz give me the source codes It's not possible to write whole code for you. You need to try and write the necessary code. If that do not works please come back here with the details of the problem you are facing with the tried code. Hope you understand.

SADAM HUSSAIN · Answer

Plz give me the suggestion.given below my code { Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook excelBook = excelApp.Workbooks.Open(OpenDialogBox.FileName.ToString() 0 true 5   true Microsoft.Office.Interop.Excel.XlPlatform.xlWindows 	 false false 0 true 1 0); Microsoft.Office.Interop.Excel.Worksheet excelSheet = (Microsoft.Office.Interop.Excel.Worksheet)excelBook.Worksheets.get_Item(1); ; Microsoft.Office.Interop.Excel.Range excelRange = excelSheet.UsedRange; string strCellData = ; double douCellData; int rowCnt = 0; int colCnt = 0; DataTable dt = new DataTable(); for (colCnt = 1; colCnt { string strColumn = ; strColumn = (string)(excelRange.Cells[1 colCnt] as Microsoft.Office.Interop.Excel.Range).Value2; dt.Columns.Add(strColumn typeof(string)); } for (rowCnt = 2; rowCnt { string strData = ; for (colCnt = 1; colCnt { try { strCellData = (string)(excelRange.Cells[rowCnt colCnt] as Microsoft.Office.Interop.Excel.Range).Value2; strData += strCellData + |; } catch (Exception ex) { douCellData = (excelRange.Cells[rowCnt colCnt] as Microsoft.Office.Interop.Excel.Range).Value2; strData += douCellData.ToString() + |; } } strData = strData.Remove(strData.Length - 1 1); dt.Rows.Add(strData.Split('|')); } dgcFeesEntry.ItemsSource = dt.DefaultView; excelBook.Close(true null null); excelApp.Quit(); }