Excel ClosedXML ProtectedView

Question

Hi I have a requirement where in need to read excel from a location and update its certain cells and then save it to different location.I wrote a code snippet using ClosedXML

using (var workbook = new XLWorkbook(excelFilePath))
 {     foreach (var worksheet in workbook.Worksheets)  
   {         // Your code to work with each worksheet goes here         // ...     }  
    // Save the workbook if needed     workbook.SaveAs(excelFilePath); 
}

Challenge - if the excel is in protectedMode nothing works... (Open Source - ClosedXML) Any help can get me going... Thnaks

Answer 1

Hi @SSinhg There is an article about this here: https://docs.closedxml.io/en/latest/features/protect.html