C＃EPPlus OpenXML的计算行 [英] C# EPPlus OpenXML count rows

问题描述

随着EPPlus和OpenXML的没有人知道如何计算行数的语法？

With EPPlus and OpenXML does anyone know the syntax on how to count the rows?

说我的工作被称为工作表

Say my worksheet is called "worksheet"

INT numberRows = worksheet.rows.count（）？或 worksheet.rows.dimension

我在回答cetainly感兴趣，但如何找到答案将很酷，像去定义，并期待这个或那个，等等。

I'm cetainly interested in the answer, but how to find the answer would be cool to, like "Go to definition" and look for this or that, etc.

感谢

推荐答案

通过所谓的工作表工作表对象，worksheet.Dimension.Start.Row和worksheet.Dimension.End.Row应该给你你需要的信息。

With a worksheet object called 'worksheet', worksheet.Dimension.Start.Row and worksheet.Dimension.End.Row should give you the information you need.

worksheet.Dimension.Address会给你包含在传统的Excel范围格式的工作表尺寸的字符串（例如A1：I5'的行1-5，列1-9）。

worksheet.Dimension.Address will give you a string containing the worksheet dimensions in the traditional Excel range format (e.g. 'A1:I5' for rows 1-5, columns 1-9).

有一个文档文件提供。在许多情况下，它可能是可以快速地玩弄图书馆，找到答案的方式。 EPPlus似乎是精心设计的 - 一切似乎在逻辑上命名，至少

There is a documentation file available. In many cases it might be just as quick to play around with the library and find the answer that way. EPPlus seems to be well designed - everything seems to be logically named, at least.

这篇关于C＃EPPlus OpenXML的计算行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！