How to add column names in excel into list in asp.net

Neelima chunchu 0
Viewed 42

I want the elements of the first column of an Excel sheet to be added to the list.

This is my code:

var list = new List<string>();

using (var stream = new MemoryStream())
{
    await file.CopyToAsync(stream);

    ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

    using (var package = new ExcelPackage(stream))
    {
        ExcelWorksheet worksheet = package.Workbook.Worksheets[0];
        var rowcount = worksheet.Dimension.Rows;
        var columncount = worksheet.Dimension.Columns;
        var column = worksheet.Rows[1].Range.Value;
        var range = worksheet.Rows.Range.Value;
        var row = worksheet.Columns[1].Range.Value;

        list.Add(column.ToString());
    }
}
asp.net-web-api asp.net-mvc asp.net asp.net-core c#
1 Answers
for(int i = 1; i <= columncount; i++)
{
      var field1 = worksheet.Cells[1,i].Value as string;
      list.Add(field1);
      field1 = null;
}

this loop will give the first column names

Neelima chunchu0
Related