Click here to Skip to main content
12,553,861 members (66,967 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# ASP.NET
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 21-Nov-12 0:54am
Updated 21-Nov-12 19:15pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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]

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.161021.1 | Last Updated 22 Nov 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100