获取每个工作表的列计数 Excell 库

Question

我正在使用ExcelLibrary软件包。想知道如何确定每张工作表的列数？

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

Answer 1

试试

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