0

I am using the ExcelLibrary package. Was wondering how to determine the amount of columns per work sheet?.

var workbook = Workbook.Load(fileToValidate);
foreach (var v in workbook.Worksheets)
{
     //coulmn count for each sheet

}
Arianule
  • 8,811
  • 45
  • 116
  • 174

1 Answers1

1

Try

var workbook = Workbook.Load(fileToValidate);
foreach (var v in workbook.Worksheets)
{
     //coulmn count for each sheet
     int count = v.Columns.Count();

}
Plue
  • 1,739
  • 1
  • 18
  • 22