Articles → .NET → Read Password Protected Excel File In C#

Read Password Protected Excel File In C#







Picture showing the sample password protected excel file
Click to Enlarge



Microsoft.Office.Interop.Excel.Application excelObject = new Microsoft.Office.Interop.Excel.Application();

Microsoft.Office.Interop.Excel.Workbook workBookObject = null;
Microsoft.Office.Interop.Excel.Sheets sheetObject = null;
Microsoft.Office.Interop.Excel.Worksheet workSheetObject = null;
Microsoft.Office.Interop.Excel.Range range = null;

//  Get information for the workbook
workBookObject = excelObject.Workbooks.Open("file_path", Type.Missing, Type.Missing, Type.Missing, "password_on_file", Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

sheetObject = workBookObject.Worksheets;

workSheetObject = (Microsoft.Office.Interop.Excel.Worksheet) sheetObject.get_Item(1); //Get the reference of second worksheet

range = workSheetObject.UsedRange;
DataTable dt = new DataTable();
dt.Columns.Add("MemberName");
for (int row = 2; row <= range.Rows.Count; row++) {
  DataRow dr = dt.NewRow();
  for (int column = 1; column <= range.Columns.Count; column++) {
    dr[column - 1] = (range.Cells[row, column] as Microsoft.Office.Interop.Excel.Range).Value2.ToString();
  }
  dt.Rows.Add(dr);
}

//  Dispose objects
workBookObject.Close(false, System.Reflection.Missing.Value, System.Reflection.Missing.Value);
excelObject.Quit();
Marshal.ReleaseComObject(workSheetObject);
Marshal.ReleaseComObject(workBookObject);
Marshal.ReleaseComObject(excelObject);

excelObject = null;
workBookObject = null;
sheetObject = null;
workSheetObject = null;



Output


Picture showing the data read from the password protected excel file
Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Friday, January 16, 2015

Query/Feedback


Your Email Id
 
Subject
 
Query/FeedbackCharacters remaining 250