How to count number of columns Excel file in ClosedXML?

Question

I tried to do that using code:

worksheet.Columns.count();

But there is not method count() for Columns

All code is:

 class ExcelReader
    {

        private XLWorkbook workbook;
        private string file;
        private IXLWorksheet worksheet;


        public ExcelReader(string file) {

            this.workbook = new XLWorkbook(file);
        }

        private void ChooseWorksheet(int sheet) {

            this.worksheet = workbook.Worksheet(sheet);
        } 

        public int NumberColumns() {

            return this.worksheet.Columns.Count();
        }
}

Tough it may seem obvious to you, what **exactly** is worksheet? Please provide a little bit more code — Romano Zumbé, Jun 30 '17 at 07:11

score 3 · Accepted Answer · answered Jun 30 '17 at 07:44

Looking at the code from https://github.com/ClosedXML/ClosedXML Count should work using LINQ, since IXLColumns implemments IEnumerable<IXLColumn> IXLColumns: IEnumerable

If you are getting a method missing on Count, means you are missing

using System.Linq;

score 1 · Answer 2 · answered Jun 28 '18 at 17:58

1

I was trying to do the same thing. The following worked for me:

worksheet.Columns().Count()

answered Jun 28 '18 at 17:58

Nate Anderson

777
2
7
26

How to count number of columns Excel file in ClosedXML?

2 Answers2