blocks|key|4515881|text|要访问行，请执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4515882|var+row+=+ws1.Row(3);|code-block|syntax|javascript|4515883|要检查行是否为空，请执行以下操作：|4515884|bool+empty+=+row.IsEmpty();|4515885|要访问行中的单元格(列)：|4515886|var+cell+=+row.Cell(3);|4515887|要从单元格获取值，请执行以下操作：|4515888|object+value+=+cell.Value;
//+or
string+value+=+cell.GetValue<string>();|4515889|有关详细信息，请参阅documentation。|offset|length|4515890|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/closedxml/closedxml/wiki/Cell-Values^0|0|0|0|0|0|0|0|0|A|D|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|16|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|18|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|19|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|1A|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|1C|8|@]|9|@$U|1D|V|1E|1|1F]]|A|$]]|$1|W|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

To access a row:

<pre><code>var row = ws1.Row(3);
</code></pre>

To check if the row is empty:

<pre><code>bool empty = row.IsEmpty();
</code></pre>

To access a cell (column) in a row:

<pre><code>var cell = row.Cell(3);
</code></pre>

To get the value from a cell:

<pre><code>object value = cell.Value;
// or
string value = cell.GetValue&lt;string&gt;();
</code></pre>

For more information see the <a href="https://github.com/closedxml/closedxml/wiki/Cell-Values" rel="noreferrer">documentation</a>.

blocks|key|4515928|text|我更喜欢使用RowsUsed()方法来获取那些非空的或者已经被用户编辑过的行的列表。这样，我就可以避免检查每一行是否为空。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4515929|我不确定它是否符合您在帖子中描述的确切问题陈述，但此代码片段可以帮助您处理所有非空行中的第3行到第20行，因为我在开始处理之前已经过滤掉了空行。在开始处理之前过滤非空行可能会影响您实际要处理的行号。|4515930|但我觉得在处理excel表格的行时，RowsUsed()方法在任何一般情况下都是非常有用的。|4515931|string+fileName+=+"C:\\Folder1\\Prev.xlsx";
using+(var+excelWorkbook+=+new+XLWorkbook(fileName))
{
++++var+nonEmptyDataRows+=+excelWorkbook.Worksheet(1).RowsUsed();

++++foreach+(var+dataRow+in+nonEmptyDataRows)
++++{
+++++++//for+row+number+check
+++++++if(dataRow.RowNumber()+>=3+&&+dataRow.RowNumber()+<=+20)
+++++++{
+++++++++++//to+get+column+#+3's+data
+++++++++++var+cell+=+dataRow.Cell(3).Value;
+++++++}
++++}
}|code-block|syntax|javascript|4515932|entityMap^0|6|A|0|0|I|A|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|T|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|U|8|@$9|V|A|W|B|C]]|D|@]|E|$]]|$1|J|3|K|5|L|7|X|8|@]|D|@]|E|$M|N]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

I prefer using <code>RowsUsed()</code> method to get a list of only those rows which are non-empty or has been edited by the user. This way I can avoid making checks for each row whether it is empty or not.

I'm not sure if it will fit the exact problem statement which you've described in your post but this code snippet can help you process 3rd to 20th row numbers out of all the non-empty rows as I've filtered out the empty rows before starting to process. Filtering the non-empty rows before I start processing can affect the row numbers you actually intend to process. 

But I feel that <code>RowsUsed()</code> method is very helpful in any general scenario when you are processing the rows of an excel sheet.

<pre><code>string fileName = "C:\\Folder1\\Prev.xlsx";
using (var excelWorkbook = new XLWorkbook(fileName))
{
 var nonEmptyDataRows = excelWorkbook.Worksheet(1).RowsUsed();

 foreach (var dataRow in nonEmptyDataRows)
 {
 //for row number check
 if(dataRow.RowNumber() &gt;=3 &amp;&amp; dataRow.RowNumber() &lt;= 20)
 {
 //to get column # 3's data
 var cell = dataRow.Cell(3).Value;
 }
 }
}
</code></pre>

blocks|key|8440|text|这是我的果酱。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|8441|var+rows+=+worksheet.RangeUsed().RowsUsed().Skip(1);+//+Skip+header+row
foreach+(var+row+in+rows)
{
++++var+rowNumber+=+row.RowNumber();
++++//+Process+the+row
}|code-block|syntax|javascript|8442|如果你只使用.RowsUsed()，你的范围将包含大量的列。比实际填写的要多得多！|offset|length|style|CODE|8443|因此，首先使用.RangeUsed()来限制范围。这将帮助您更快地处理文件！|8444|还可以使用.Skip(1)跳过列标题行(如果有列标题行)。|8445|entityMap^0|0|0|6|B|0|7|C|0|5|8|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|X|8|@$I|Y|J|Z|K|L]]|9|@]|A|$]]|$1|O|3|P|5|6|7|10|8|@$I|11|J|12|K|L]]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|R|$]]

Here's my jam.

<pre><code>var rows = worksheet.RangeUsed().RowsUsed().Skip(1); // Skip header row
foreach (var row in rows)
{
 var rowNumber = row.RowNumber();
 // Process the row
}
</code></pre>

If you just use <code>.RowsUsed()</code>, your range will contain a huge number of columns. Way more than are actually filled in!

So use <code>.RangeUsed()</code> first to limit the range. This will help you process the file faster!

You can also use <code>.Skip(1)</code> to skip over the column header row (if you have one).

My Excel file is not in tabular data. I am trying to read from an excel file.
I have sections within my excel file that are tabular.

I need to loop through rows 3 to 20 which are tabular and read the data.

Here is party of my code:

<pre><code> string fileName = "C:\\Folder1\\Prev.xlsx";
 var workbook = new XLWorkbook(fileName);
 var ws1 = workbook.Worksheet(1); 
</code></pre>

How do I loop through rows 3 to 20 and read columns 3,4, 6, 7, 8? 
Also if a row is empty, how do I determine that so I can skip over it without reading that each column has a value for a given row.

Reading from Excel File using ClosedXML

我的Excel文件不在表格数据中。我正在尝试从excel文件中读取。我在我的excel文件中有表格形式的部分。我需要遍历表格形式的第3行到第20行，并读取数据。下面是我的代码片段：     string fileName = "C:\\Folder1\\Prev.xlsx";     var workbook = ne...

问用ClosedXML读取Excel文件
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用ClosedXML读取Excel文件EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用ClosedXML读取Excel文件
EN