/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

22 votes116 views6 answers
Console.writeline
C#
2 votes164 views1 answer
Unity rotate around pivot c#
C#Unity
10 votes114 views2 answers
C# string contains
C#
0 vote129 views1 answer
C# keep console open
C#
3 votes149 views1 answer
Spawn a object with unity
C#Unity
1 vote116 views1 answer
Best way to compare byte array c#
C#
31 votes105 views4 answers
C# convert string to datetime any format
C#
3 votes104 views1 answer
How to load the active scene unity
C#
1 vote125 views1 answer
Unity get a position inside sphere
C#Unity
0 vote102 views1 answer
Unity make particles stay still
C#