change default column header while importing data from an excel sheet

Question

I have a gridview which has 4 columns in total now the first column name i am importing from an excel sheet which is named as "FileName".the gridview is taking columnheader as F1 instead of filename.i need that f1 to be replaced with my column header name.

so far I have tried

dataGridView1.Columns[0].Name = "Filename";
dtExcel.Columns.Add("Filename");
dataGridView1.Columns[0].HeaderText = "Filename"

by this, all new column of the filename is getting added but that F1 is not getting replaced.

Help Please.

Lara · Accepted Answer · 2017-02-15 11:26:56Z

1

Daclare a GridView for example: GridView1 Now before uploading your excel, make the column Name the one you want with below code

GridView1.Columns[0].HeaderText = "SampleCoumnName"; //1st Column
GridView1.Columns[1].HeaderText = "SampleCoumnName2";//2nd Column

Now upload the Excel file in the above Grid "GridView1". Do your work and export from same Grid.

Update2:

DataRow row = datatable.Rows[0];
dt.Rows.Remove(row);
GridView1.DataSource = dt;

Above Snippet believes, you are adding excel values into DataTable. If this, Get the 0 row. Remove that row and then upload into your Griview with the desired column name you added with your code. This way it will not override your coded column Names.

edited Feb 15, 2017 at 11:26

answered Feb 15, 2017 at 8:07

Lara

3,05110 gold badges46 silver badges83 bronze badges

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

4 Comments

Nazneen Sayed Over a year ago

i am not using database here lara.user already has one excel file which i need to import and then edit data in grid and export.now import and exporting is working fine just that grid is taking F1 as default column header which i need to replace with my column header as "Filename"

Nazneen Sayed Over a year ago

already tried that but its not working as the imported data from the available excel already has that column so its taking default as f1 only and when i perform GridView1.Columns[0].HeaderText = "Filename"; new column is getting added however the imported data from excel remains exactly same there's F1 in header then in first row filename then the contents of excel.i just need that imported excel header text to be filename in place of F1.

Nazneen Sayed Over a year ago

ok will try that but what about that F1 default value ?its not getting removed i even tried making columnheader property value as false but then my coded header values also become invisible so is there a way to add heading to datagrid cells? like in first row? my excel only has 1 column but after import another 3 columns need to be added.

Nazneen Sayed Over a year ago

snag.gy/Y0V8CZ.jpg please check this image Lara for better understanding.

Nazneen Sayed · Accepted Answer · 2017-02-15 10:55:52Z

0

resolved this myself just needed to change the Query from select * from [Sheet$] to select F1 as Filename from [Sheet$]

thanks for the help guys.

answered Feb 15, 2017 at 10:55

Nazneen Sayed

94 bronze badges

Collectives™ on Stack Overflow

change default column header while importing data from an excel sheet

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related