blocks|key|2025399|text|第一个值用于冻结多少行，第二个值用于冻结多少列。因此，要冻结前3行和5列，您需要按以下方式调用它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2025400|Worksheets.View.FreezePanes(3,+5);|code-block|syntax|javascript|2025401|您还可以查看这个问题，以获得有关FreezePanes的更多信息。|offset|length|style|CODE|2025402|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/18190918/freezing-columns-in-epplus-an-excel-split-function^0|0|0|G|B|6|4|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]]|9|@$I|Z|J|10|1|11]]|A|$]]|$1|M|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

The first value is for how many rows you want frozen, and the second is for how many columns you want frozen. Therefore, to freeze the first 3 rows and 5 columns you would need to call it as the following:

<pre><code>Worksheets.View.FreezePanes(3, 5);
</code></pre>

You can also take a look at <a href="https://stackoverflow.com/questions/18190918/freezing-columns-in-epplus-an-excel-split-function">this SO question</a> for more information on <code>FreezePanes</code>.

blocks|key|211190|text|对于我来说，冻结第一行代码是有效的。我不知道那是什么逻辑。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|211191|+worksheet.View.FreezePanes(2,1);|code-block|syntax|javascript|211192|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For me to freeze the first row following code worked. I am not sure what is logic there.

<pre><code> worksheet.View.FreezePanes(2,1);
</code></pre>

blocks|key|2025438|text|从ExcelWorksheet对象中，访问视图属性。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2025439|在返回的ExcelWorksheetView对象上，调用FreezePanes(行、列)方法，传递第一个单元格(未冻结)的行和列。|2025440|例如，要冻结第一个完整的两个Excel工作表窗格，您需要将列(3,1)传递给row参数：|2025441|worksheetObject.View.FreezePanes(3,+1);|code-block|syntax|javascript|2025442|因此，要只冻结第一行，完全，您现在只可以调用worksheetObject.View.FreezePanes(2,1);！|CODE|2025443|这是也提过在EPPlus的官方例子中。|2025444|因此，要回答@+answer+2148124提出的原始问题，答案应该是|2025445|worksheetObject.View.FreezePanes(3,+5);|2025446|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/EPPlusSoftware/EPPlus/wiki/Freeze-and-Split-Panes^0|L|2|0|S|G|1B|C|0|U|5|0|0|4|9|M|12|0|2|3|0|0|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|18|8|@$9|19|A|1A|B|C]|$9|1B|A|1C|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|1D|8|@$9|1E|A|1F|B|C]]|D|@]|E|$]]|$1|J|3|K|5|L|7|1G|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|1H|8|@$9|1I|A|1J|B|C]|$9|1K|A|1L|B|Q]]|D|@]|E|$]]|$1|R|3|S|5|6|7|1M|8|@]|D|@$9|1N|A|1O|1|1P]]|E|$]]|$1|T|3|U|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|V|3|W|5|L|7|1R|8|@]|D|@]|E|$M|N]]|$1|X|3|-4|5|6|7|1S|8|@]|D|@]|E|$]]]|Y|$Z|$5|10|11|12|E|$13|14]]]]

From the ExcelWorksheet object, access the View property.
On the returned ExcelWorksheetView object, call the FreezePanes(row, column) method, passing the row and column of the first cell which is NOT frozen.
For example, to freeze the first complete two panes of Excel Worksheet, you would need to pass in the column (3,1) to the row parameter:
<pre><code>worksheetObject.View.FreezePanes(3, 1);
</code></pre>
So to Freeze only first row completely you can now call <code>worksheetObject.View.FreezePanes(2,1);</code> only!
This is <a href="https://github.com/EPPlusSoftware/EPPlus/wiki/Freeze-and-Split-Panes" rel="nofollow noreferrer">also mentioned</a> in official Example of EPPlus.
Therefore to answer original question raised by @user2148124 the answer should be
<pre><code>worksheetObject.View.FreezePanes(3, 5);
</code></pre>

blocks|key|2025477|text|我知道上一篇关于这个主题的文章已经有很长一段时间了，但是我最近正在处理这个问题，我找到了得到我想要的东西的方法(EPPlus+v4.5.3)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2025478|public+static+void+FreezeHeader(ExcelWorksheet+sheet)
{
++++++++var+xdoc+=+sheet.WorksheetXml;

++++++++var+sheetViews+=+xdoc.GetElementsByTagName("sheetViews");
++++++++var+sheetViewNode+=+sheetViews[0].ChildNodes[0];

++++++++var+paneNode+=+xdoc.CreateNode(System.Xml.XmlNodeType.Element,+"pane",+xdoc.DocumentElement.NamespaceURI);

++++++++var+ySplit+=+xdoc.CreateAttribute("ySplit");
++++++++ySplit.Value+=+"1";

++++++++var+topLeftCell+=+xdoc.CreateAttribute("topLeftCell");
++++++++topLeftCell.Value+=+"A2";

++++++++var+activePane+=+xdoc.CreateAttribute("activePane");
++++++++activePane.Value+=+"bottomLeft";

++++++++var+state+=+xdoc.CreateAttribute("state");
++++++++state.Value+=+"frozen";

++++++++paneNode.Attributes.Append(ySplit);
++++++++paneNode.Attributes.Append(topLeftCell);
++++++++paneNode.Attributes.Append(activePane);
++++++++paneNode.Attributes.Append(state);

++++++++sheetViewNode.AppendChild(paneNode);
}|code-block|syntax|javascript|2025479|我通过比较两个Excel文件的xml+(一个带有冻结的头文件，另一个使用了witouht)实现了这一点。|2025480|通常，在创建一个简单的excel文件时，您会得到以下内容：|2025481|<sheetViews>
+++<sheetView+workbookViewId="0">
+++</sheetView>
</sheetViews>|2025482|现在，如果冻结第一行并检查xml，您将看到：|2025483|<sheetViews>
<sheetView+tabSelected="1"+topLeftCell="Z1"+zoomScale="85"+zoomScaleNormal="85"+workbookViewId="0">
++++<pane+ySplit="1"+topLeftCell="A213"+activePane="bottomLeft"+state="frozen"/>
++++<selection+activeCell="O1"+sqref="O1"/><selection+pane="bottomLeft"+activeCell="AD229"+sqref="AD229"/>
</sheetView>|2025484|由此推断，必须将“窗格”节点添加到xml结构中：|2025485|<pane+ySplit="1"+topLeftCell="A213"+activePane="bottomLeft"+state="frozen"/>|2025486|这就是我提供的代码所做的:-)|2025487|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|11|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|12|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|13|8|@]|9|@]|A|$]]|$1|O|3|P|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|Q|3|R|5|6|7|15|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|16|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|17|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

I know it's a long time since last post in the topic, but I was recently dealing with this problem and I found that way to get what I wanted (EPPlus v4.5.3):
<pre><code>public static void FreezeHeader(ExcelWorksheet sheet)
{
 var xdoc = sheet.WorksheetXml;

 var sheetViews = xdoc.GetElementsByTagName(&quot;sheetViews&quot;);
 var sheetViewNode = sheetViews[0].ChildNodes[0];

 var paneNode = xdoc.CreateNode(System.Xml.XmlNodeType.Element, &quot;pane&quot;, xdoc.DocumentElement.NamespaceURI);

 var ySplit = xdoc.CreateAttribute(&quot;ySplit&quot;);
 ySplit.Value = &quot;1&quot;;

 var topLeftCell = xdoc.CreateAttribute(&quot;topLeftCell&quot;);
 topLeftCell.Value = &quot;A2&quot;;

 var activePane = xdoc.CreateAttribute(&quot;activePane&quot;);
 activePane.Value = &quot;bottomLeft&quot;;

 var state = xdoc.CreateAttribute(&quot;state&quot;);
 state.Value = &quot;frozen&quot;;

 paneNode.Attributes.Append(ySplit);
 paneNode.Attributes.Append(topLeftCell);
 paneNode.Attributes.Append(activePane);
 paneNode.Attributes.Append(state);

 sheetViewNode.AppendChild(paneNode);
}
</code></pre>
I achieved this by comparing the xml of two Excel files (one with freezed header and another witouht).
Typically when creating a simple excel file, you get the following :
<pre><code>&lt;sheetViews&gt;
 &lt;sheetView workbookViewId=&quot;0&quot;&gt;
 &lt;/sheetView&gt;
&lt;/sheetViews&gt;
</code></pre>
Now if you freeze the first row and examine the xml, you will see that :
<pre><code>&lt;sheetViews&gt;
&lt;sheetView tabSelected=&quot;1&quot; topLeftCell=&quot;Z1&quot; zoomScale=&quot;85&quot; zoomScaleNormal=&quot;85&quot; workbookViewId=&quot;0&quot;&gt;
 &lt;pane ySplit=&quot;1&quot; topLeftCell=&quot;A213&quot; activePane=&quot;bottomLeft&quot; state=&quot;frozen&quot;/&gt;
 &lt;selection activeCell=&quot;O1&quot; sqref=&quot;O1&quot;/&gt;&lt;selection pane=&quot;bottomLeft&quot; activeCell=&quot;AD229&quot; sqref=&quot;AD229&quot;/&gt;
&lt;/sheetView&gt;
</code></pre>

From that I deduced I had to add the &quot;pane&quot; node to the xml structue:
<pre><code>&lt;pane ySplit=&quot;1&quot; topLeftCell=&quot;A213&quot; activePane=&quot;bottomLeft&quot; state=&quot;frozen&quot;/&gt;
</code></pre>
That's what the code I provide is doing :-)

blocks|key|1507377|text|您可以调用sheet.FreezePanes(int+rowIndex，int+columnIndex)方法来设置冻结区域。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|1507378|代码示例：|1507379|using+System;
using+Spire.Xls;
using+System.Drawing;

namespace+FreezePane
{
++++class+Program
++++{
++++++++static+void+Main(string[]+args)
++++++++{
++++++++++++//Load+File
++++++++++++Workbook+workbook+=+new+Workbook();
++++++++++++workbook.LoadFromFile
++++++++++++++++(@"E:\Work\Documents\ExcelFiles\UserInfo.xlsx");
++++++++++++Worksheet+sheet+=+workbook.Worksheets[0];

++++++++++++//Freeze+Top+Row
++++++++++++sheet.FreezePanes(2,+1);

++++++++++++//Save+and+Launch
++++++++++++workbook.SaveToFile("FreezePane.xlsx",+ExcelVersion.Version2010);
++++++++++++System.Diagnostics.Process.Start(workbook.FileName);
++++++++}
++++}
}|code-block|syntax|javascript|1507380|entityMap^0|5|1B|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|R|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|S|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|T|8|@]|D|@]|E|$]]]|N|$]]

You can invoke sheet.FreezePanes(int rowIndex, int columnIndex) method to set freezing area.

Code Sample:

<pre><code>using System;
using Spire.Xls;
using System.Drawing;

namespace FreezePane
{
 class Program
 {
 static void Main(string[] args)
 {
 //Load File
 Workbook workbook = new Workbook();
 workbook.LoadFromFile
 (@"E:\Work\Documents\ExcelFiles\UserInfo.xlsx");
 Worksheet sheet = workbook.Worksheets[0];

 //Freeze Top Row
 sheet.FreezePanes(2, 1);

 //Save and Launch
 workbook.SaveToFile("FreezePane.xlsx", ExcelVersion.Version2010);
 System.Diagnostics.Process.Start(workbook.FileName);
 }
 }
}
</code></pre>

I want to freeze first 5 columns and three rows in excel.
I have written the following code for that

<pre><code>Worksheets.View.FreezePanes(5, 5);
</code></pre>

but it freezes columns in first 4 rows also.
I want to freeze first 4 columns in excel except in first 4 rows.
Is it possible to do?

Freeze panes in Excel using C# and EPPlus

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我想冻结excel中的前5列和3行。我已经为此编写了以下代码Worksheets.View.FreezePanes(5, 5);但它也冻结了前4行的列。除前4行外，我想冻结excel中的前4列。做得到吗？

问使用C#和EPPlus在Excel中冻结窗格
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用C#和EPPlus在Excel中冻结窗格EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用C#和EPPlus在Excel中冻结窗格
EN