vsto 获取 sheet.Range[“C3:D100“]结束行

最新推荐文章于 2023-09-06 18:21:50 发布

BugLovers

最新推荐文章于 2023-09-06 18:21:50 发布

阅读量109

点赞数

分类专栏： vsto 文章标签： vsto

本文链接：https://blog.csdn.net/nbspzs/article/details/130785767

版权

vsto 专栏收录该内容

108 篇文章 8 订阅

订阅专栏

In VSTO (Visual Studio Tools for Office), you can use the following code snippet to get the end row of the range "C3:D100" in Excel:

```csharp
Excel.Range range = worksheet.Range["C3:D100"];
int endRow = range.Rows.Count + range.Row - 1;
```

This code assumes you have a reference to the Excel `Worksheet` object named `worksheet`. The `Rows.Count` property gives the number of rows in the range, and the `Row` property gives the starting row number of the range. By adding these values and subtracting 1, you can determine the end row of the range. The result will be stored in the `endRow` variable.

结束行位置是100