打开XML Excel:不可编辑的列

本文介绍了打开XML Excel:不可编辑的列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

HI Friends， 请在以下遇到问题的情况下帮助我. 使用DocumentFormat.OpenXML dll的类/方法.创建了一个excel文件. 必需:需要向用户显示excel文件，其中某一列为只读. 这是必需的.我已经在网上搜索过，对我没有任何帮助. 我不知道是否有可能.如果可能，如何实现. 朋友，请做有需要的人.这是非常紧急的要求.

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.

推荐答案

您是否提到了开放的xml规范? 如果您用Google搜索"标准ECMA-376 Office Open XML文件格式"，则应该找到它...请参阅18.8.33保护(保护属性)部分. 就像您在excel中一样.即将单元格标记为受保护...然后保护工作表. [edit]不必要的代码块已删除[/edit] 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]