Power Query Excel data from Variable

[nicolast29]

Hi

I will have a lot of sheet from a excel file to import

I want to improve the import so i will optimize one and past copy with the minimum of modifications

I find how to use a reference to the number of the sheet instead of the name

My next problem is :

After = Table.PromoteHeaders operation the information in the first row with be a different name 

I want to find a solution to replace it whatever the content

Thansk for helping

https://1drv.ms/u/s!AoqtZHsX4BzvhIQX-v9bn0gyglmzIw?e=g4j6Z3

[AntonioM · Accepted solution]

= Table.RenameColumns(#"Promoted Headers", {Table.ColumnNames(#"Promoted Headers"){0}, "Column Name"})

That will rename the first column in the table, whatever it's called.

[nicolast29]

Hi

Thanks

It is so simple and beautifull

Have a nice day