/C#/Office open xml check if row is empty

Office open xml check if row is empty

var sheetData = part.Worksheet.Elements<SheetData>().First();
var rows = sheetData.Elements<Row>().ToList();
for (var rowIndex = 0; rowIndex < rows.Count; rowIndex++)
{
  var row = rows[rowIndex];
  if (string.IsNullOrWhiteSpace(row.InnerText)) continue;
  // Row is not empty
}

Similar codes

9 votes101 views2 answers
Cast int as enum c# microsoft
C#
2 votes141 views1 answer
Compare two strings in c#
C#
0 vote171 views1 answer
Unity how to check index of enum
C#Unity
0 vote135 views1 answer
Tostring c#
C#
0 vote129 views1 answer
C# getting response content from post
C#
10 votes127 views6 answers
How to define a function in c#
C#
2 votes128 views1 answer
Unity default rotation
C#
0 vote152 views1 answer
Blocked script execution in '<url>' because the document's frame is sandboxed and the 'allow-scripts' permission is not set.
C#
0 vote130 views1 answer
C# datagridview filter textbox
C#
5 votes130 views2 answers
How to get element dictionary key in c# by index
C#