Unanswered

Add Same headers to created excel sheets.

(0) Share

Report

Posted on by Natron26

I have a automation where i will be creating multiple excel sheet with tables of information. Each excel sheet will have the same column headers. See below the 4 header names for each excel sheet. See below. How would I make sure that once the excel sheet is created the headers below are added? Is there also a way to extract certain columns of information from a datable from the web?

Column/Header 1 = OrgName

Column/Header 2 = Letter

Column/Header 3 = Model

Column/Header 4 = Year

Categories:

Power Automate Desktop

I have the same question (2)

All responses (3)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Natron26

Normally power automate should have the feature to add headers when datatable is written to excel file, but it don't have 😞

So alternatively, you can try the below approach to add headers to an excel file :

first step will create a datatable with headers as one row value like below:

Then while writing the variable to excel , you will see results like below:

For extarcting information from web, you need use extract data from webpage action 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
Natron26 on at

Like (0)

Report

Thanks for this, I was thinking the same thing just wasn't sure how to write the code in the set variable for the columns, this will also help out in other parts of this automation. Thanks for the help nice work.

Was this reply helpful? Yes No
Natron26 on at

Like (0)

Report

Maybe you could help me with the below question I posted earlier?
https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Extracting-Chosen-information-from-online-data-table-writing-to/m-p/2556180

Was this reply helpful? Yes No