Click here to Skip to main content
15,850,298 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
HI Friends,

Please help me in the following scenario which I got stucked.

Using DocumentFormat.OpenXML dll's classes/methods. One excel file is created.

Required : Need to show that excel file to user with one particular column as read only.

This is the requirement. I have searched the web and nothing is helpful to me.

I don't whether it is possible or not. If possible , how to achieve this.

Friends, please do the needful. It is very urgent requirement.
Posted
Updated 21-Nov-12 20:15pm
v4

1 solution

Hi,
Have you referred to the open xml specification?

if you google "Standard ECMA-376 Office Open XML File Formats" you should find it...see the section 18.8.33 protection (Protection Properties)

This is the same as if you were doing it in excel. i.e. mark cell as protected... then protect the worksheet.

[edit]unnecesary code block removed[/edit]
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900