Read Excel file without headers ASP.Net

Question

I am trying to follow this code to read Excel files. Unfortunately, I cannot make it work, because I need to read Excel files without headers. How can I read an Excel files without headers?

public static DataTable ToDataTable(this ExcelPackage package)
    {
        ExcelWorksheet workSheet = package.Workbook.Worksheets.First();
        DataTable table = new DataTable();


        foreach (var firstRowCell in workSheet.Cells[1, 1, 1, workSheet.Dimension.End.Column])
        {
            table.Columns.Add(firstRowCell.Text);
        }

        for (var rowNumber = 2; rowNumber <= workSheet.Dimension.End.Row; rowNumber++)
        {
            var row = workSheet.Cells[rowNumber, 1, rowNumber, workSheet.Dimension.End.Column];
            var newRow = table.NewRow();
            foreach (var cell in row)
            {
                    newRow[cell.Start.Column-1] = cell.Text;
            }
            table.Rows.Add(newRow);  
        }
        return table;
    }

maybe try something like this one stackoverflow.com/questions/13396604/… with bool hasHeader = false; — Slai
– Slai, Commented Jan 30, 2017 at 2:20

Ghasan غسان · Accepted Answer · 2017-01-30 02:59:08Z

1

You can see in the for statement that it loops starting from the second row (skipping the header), what you need is to loop from the first row (as there is no header row) like this:

var rowNumber = 1

If your data is empty at the first row, then please add how many columns you are expecting to be there in the file:

// Notice I replaced workSheet.Dimension.End.Column with 6, because I am expecting 6 columns.
foreach (var firstRowCell in workSheet.Cells[1, 1, 1, 6])
{
    table.Columns.Add(firstRowCell.Text);
}

edited Jan 30, 2017 at 2:59

answered Jan 30, 2017 at 1:57

Ghasan غسان

5,9154 gold badges37 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jujumancer Over a year ago

Changed it to 1 but it gives me an error says the cannot find column 0.

Jujumancer Over a year ago

Line 30: newRow[cell.Start.Column - 1] = cell.Text;

Jujumancer Over a year ago

Basically the excel file's structure is the first row is empty.

Jujumancer · Accepted Answer · 2017-01-30 08:30:30Z

0

I was able to make a work around with the problem. I automatically added columns. Changing to foreach to a for loop.

for (int x = 0; x <= workSheet.Dimension.End.Column; x++)
        {
            table.Columns.Add(x.ToString());
        }

answered Jan 30, 2017 at 8:30

Jujumancer

1251 silver badge13 bronze badges

Collectives™ on Stack Overflow

Read Excel file without headers ASP.Net

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related