How to insert a column in existing excel in the first place?

[rahamtullah (Mohammed Rahamtullah)]

Hi @Komal_Joshi,

1. Read Excel using read range into DataTable.
2. Use Invoke method-SetOrdinal method to change column position.
3. Write the updated DataTable back to excel using write range.

Check this topic if it answers your query.

How to add a column into new datatablefrom existing datatable?

I am trying to add a column of existing datatable into new datatable. I think data add column works well but it did not works well. How to do that? Example) From Existing datatable: column(3) To New datatable: column(1) like column copy

Regards,
Rahamat