I am using the below function to protect the excel sheet with the password. The function works fine but it makes the Read-Only recommended property of the .xls document to True which allows the user to open the file without entering the password.
public void WriteProtectWorkbook(string password, string username);
Is there anyway to reset this Read-Only property to False. I am using NPOI 2.1.3 library.