title: Access Protected Excel File with ExcelDataReader and Epplus
body: <p>title pretty much says it all. Looking for a way to access a password protected excel file with ExcelDataReader and Epplus, can't find a proper answer.</p>
  
  <p>If using ExcelDataReader, my code looks like</p>
  
  <pre><code>                excelStream = File.Open(excelFilePath, FileMode.Open, FileAccess.Read);
                  excelReader = ExcelReaderFactory.CreateOpenXmlReader(excelStream);
                  excelDataSet = excelReader.AsDataSet();
  </code></pre>
  
  <p>If using EPPlus my connection code looks like</p>
  
  <pre><code>            excelPackage = new ExcelPackage(new FileInfo(excelFilePath));
              excelWorkbook = excelPackage.Workbook;
              excelSheet = excelWorkbook.Worksheets[1];
  </code></pre>
  
  <p>EPPlus has some protection related methods but i can't figure out  how to use them. ExcelDataReader doesnt seem to have any protection related methods. </p>
  
  <p>Any tips appreciated, thanks.</p>
  
  <p>EDIT: I do already know the password</p>