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(); }

How to import Excel with Password proteced file to Datagrid

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)