How to put columns name in excel file and display the transposed value in the columns.

(0) Share

Report

Posted on by Rahul_skl

Hello Everyone,

It will be grateful if someone can help me out to store the data in the first row after columns headers in excel file.

So , I am first splitting the result in text format in list and then i am trying to transpose the list values in excel file. I provide columns in the excel file but when i run the workflow the results are getting transposed and its coming in the first row . I cant see the column names all i want the results should get display in the first row after the columns headers . So , for example say i have four columns Name1, Name2 , Name3 , Name4 . I want the results to get printed for these columns .

Categories:

Power Automate Desktop

All responses (2)

Answers (1)

Sort by

Verified answer

VishnuReddy1997 2,666 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Rahul_skl ,

Please find the solution.

Code:
Please Copy the below code to your flow it will work.

SET Names TO $'''Vishnu,Vardhan,Reddy''' Text.SplitText.SplitWithDelimiter Text: Names CustomDelimiter: $''',''' IsRegEx: False Result=> HeroList Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\OneDrive\\Desktop\\Power Automate Desktop\\Practice\\Input.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance SET Column_Value TO 1 LOOP FOREACH CurrentItem IN HeroList Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: CurrentItem Column: Column_Value Row: 2 Variables.IncreaseVariable Value: Column_Value IncrementValue: 1 END

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy
Rahul_skl 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much Vishnu 🙂 Yes Its working fine now 🙂