/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

2 votes305 views1 answer
Rigidbody2d freeze position
C#
6 votes363 views1 answer
C# read all text from a file
C#
0 vote321 views1 answer
C# random sleep
C#
30 votes329 views3 answers
C# wait seconds
C#
0 vote312 views1 answer
No context type was found in the assembly enable-migrations
C#
1 vote361 views1 answer
C# datagridview row delete
C#
6 votes328 views1 answer
Db scaffolding ef core
C#
32 votes320 views6 answers
Unity enable and disable gameobject
C#
0 vote318 views1 answer
IOS app crashing on ios 15 unity
C#
0 vote371 views1 answer
Unity shader blend
C#Unity