2

What is best possible way to protect Excel work book(read only) and work sheets without using

password using SpreadsheetGear dll in c#?

pnuts
  • 58,317
  • 11
  • 87
  • 139
Avinash
  • 173
  • 1
  • 4
  • 17

1 Answers1

2

Setting IWorksheet.ProtectContents to true protects a worksheet without attaching a password to it.

SpreadsheetGear 2009 does not support workbook protection / passwords. SpreadsheetGear 2010 does support workbook protection with a new IWorkbook.Protect(...) method, and also supports reading and writing password protected workbooks. We intend to release SpreadsheetGear 2010 this summer.

Joe Erickson
  • 7,077
  • 1
  • 31
  • 31
  • hey joe can you tell me that how to make excel cell contains read only in its xml file format.currently i am using Iworksheet.Protect(). which is making it read only in excel ,but i can change value in its xml file SharedString.xml . by opening excel file with Winzip and editing SharedString.xml on any editor. – Avinash – Avinash Apr 22 '10 at 05:59