Click here to Skip to main content
Rate this: bad
good
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 1:54am
Edited 21-Nov-12 20:15pm
v4

1 solution

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

Solution 1

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]
  Permalink  
v2

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

  Print Answers RSS
0 Suvendu Shekhar Giri 245
1 Sergey Alexandrovich Kryukov 215
2 Andy Lanng 185
3 Abhinav S 184
4 PIEBALDconsult 180
0 Sergey Alexandrovich Kryukov 6,360
1 OriginalGriff 5,878
2 Peter Leow 2,514
3 Maciej Los 2,263
4 Abhinav S 2,249


Advertise | Privacy | Mobile
Web04 | 2.8.150414.1 | Last Updated 22 Nov 2012
Copyright © CodeProject, 1999-2015
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