How to column names from the worksheet without using database in asp.net

Question

                ExcelWorksheet worksheet = package.Workbook.Worksheets[0];
                var columncount =worksheet.Dimension.Columns;
                
                var rowcount = worksheet.Dimension.Rows;

here is my code, I'm getting number of columns and rows but I want column names

Qing Guo · Answer

I want column names

If the column name is in the first row, you can try the following method to get column names :

  var columnname = workSheet.Rows[1].Range.Value;

result:

How to column names from the worksheet without using database in asp.net

1 Answers