music111
1
Q:

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
}
0

New to Communities?

Join the community