How to open Excel file with Read Only protection?

Question

I have opened Excel file in my C# WinForm Application adding reference to Microsoft.Office.Interop.Excel.dll and using DSO FRAMER CONTROL. But I want to open my Excel file with read only protection. I have successfully done this for WORD Application like this:

Word.Document wordDoc = (Word.Document)axFramerControl1.ActiveDocument;
Word.Application wordApp = wordDoc.Application;
wordDoc.Protect(Word.WdProtectionType.wdAllowOnlyReading);

In the same manner, I want to do this work for Excel, but I couldn't protect the Excel file that way.

string path = "C:\\test-wb.xlsx";
axFramerControl1.Open(path, true,"excel.sheet", "", "");

Excel._Workbook excelDoc   =(Microsoft.Office.Interop.Excel._Workbook)axFramerControl1.ActiveDocument;
Excel.Application excelApp =excelDoc.Application;
// What code should I write to protect Excel Workbook with read-only ?
excelDoc.Protect(misval, true, misval);// It is not working.

gdoron · Accepted Answer · 2012-01-18 07:47:56Z

14

Call theOpen method with third parameter (ReadOnly) = true.

See MSDN documentation :

ReadOnly
Optional Object. True to open the workbook in read-only mode.

edited Jan 18, 2012 at 7:47

answered Jan 18, 2012 at 7:41

gdoron

151k59 gold badges302 silver badges376 bronze badges

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

3 Comments

Saravanan Over a year ago

:Thanks gdoron.Can you please tell where should i give that parameter in my above code that i mentioned in my question?

gdoron Over a year ago

@Saravanan. According to the MSDN, you should open with third param true. which .Net framework do you use? .Net 4?

Lukas Over a year ago

This helped me. Instead however I just added the password as the 6th parameter of the Open method.

Community · Accepted Answer · 2017-05-23 12:31:44Z

-1

The WorkBook class has a Protect method, similar (but not identical) to the one supported by Word. I can't find the COM/interop documentation, but the VSTO documentation covers the same ground, and the method signatures are the same:

Protect

Protects a workbook so that it cannot be modified.

public virtual void Protect (
    [OptionalAttribute] Object Password,
    [OptionalAttribute] Object Structure,
    [OptionalAttribute] Object Windows
)

(This all assumes that what you wanted to achieve was to protect the document, since that's what the Word code does, as opposed to opening the document read only, which is what your narrative seems to be saying, in which case, @gdoron's answer is more suitable

edited May 23, 2017 at 12:31

CommunityBot

11 silver badge

answered Jan 18, 2012 at 8:00

Damien_The_Unbeliever

241k28 gold badges358 silver badges470 bronze badges

Collectives™ on Stack Overflow

How to open Excel file with Read Only protection?

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related