C# Remove password from password protected(encrypted) excel file using the file password

Question

I am attempting to open a password protected excel file (versions xls, xlsx, xlsm). I need to open the files and remove the password from each file. I have all the passwords available for the files that are to be processed.

I cant use Microsoft Interop Excel as excel must be installed on the server for this to work. I am already using Aspose.Cells to open non password protected files. But i want to be able to save the file overwrite it without its password.

Has anybody any suggestions? Thanks in advance

Code so far

public static void RemovePassword(string filePath, string password){
  LoadOptions loadOptions = new LoadOptions();
  loadOptions.Password = password;

  Workbook src = new Workbook(filePath, loadOptions);
  //need a way of removing the password from the file.
}

Sani Huttunen · Accepted Answer · 2019-01-27 23:11:47Z

2

You can use the Unprotect method of Workbook:

LoadOptions loadOptions = new LoadOptions();
loadOptions.Password = password;

Workbook workbook = new Workbook(filePath, loadOptions);
workbook.Unprotect(password);
// or workbook.Settings.Password = "";
workbook.Save(filePath);

edited Jan 27, 2019 at 23:11

answered Jan 27, 2019 at 23:06

Sani Huttunen

24.4k7 gold badges78 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gumuruh Over a year ago

is this applied to the encrypted file to be (pass) removed?

Liam Millar · Accepted Answer · 2019-01-28 10:35:00Z

0

Thanks for your answer, I have noticed that your first suggestion only unprotects the workbooks structure.

workbook.Unprotect(password);

In my case i want to unencrypt an actual file that is password protected(encrypted)

The second suggestion works great thanks!

 workbook.Settings.Password = "";
 workbook.Save(filePath);

Thanks Again for your help

answered Jan 28, 2019 at 10:35

Liam Millar

11 silver badge1 bronze badge

Collectives™ on Stack Overflow

C# Remove password from password protected(encrypted) excel file using the file password

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related