打开XML Excel:不可编辑的列 [英] Open XML Excel : Non Editable Column

问题描述

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]

这篇关于打开XML Excel:不可编辑的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！