Hi,
I have a password protected workbook that I need to work with but no password.
Currently, using excel automation, I can open this workbook, copy it's values (not formulas) to a new sheet, and then work with the new, unprotectetd sheet.
It seems that with your excel.Open method, the data is loaded right away, so it fails requiring the password. Is there a way I can simply copy just the values of a protected worksheet using Aspose.Ecel rather than automation?
Many thanks