locked
Blank records added while importing from excel RRS feed

  • Question

  • User-1499457942 posted

    Hi

      I am importing data from excel like below . It adds few blank lines in the table which i dont want

    objbulkInsert.ColumnMappings.Add(0, 1);
                    objbulkInsert.ColumnMappings.Add(1, 2);
                    objbulkInsert.ColumnMappings.Add(2, 3);
                    objbulkInsert.ColumnMappings.Add(3, 5);
    
    
                    objbulkInsert.WriteToServer(dr);

    Thanks

    Monday, August 6, 2018 3:49 AM

All replies

  • User-821857111 posted

    This is not an ASP.NET issue. You probably have empty rows in your worksheet that are seen as data. This usually happens when you delete the content of the cells instead of the cells themselves. You need to select the row numbers on the left hand side of the worksheet then right click and choose Delete.

    Friday, August 10, 2018 2:08 PM