Data table to excel

[Try]

• Hi i want to convert data table to excel when i changed variable to excel. Spreadsheet the headers not coming only values comes in excel spreadsheet how to retrieve headers alao

[VJR]

By design the headers are not written to the Excel. PAD should have had a checkbox whether or not to write headers.

I have shared a post here to use the ColumnHeadersRow property to write the headers.

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Power-Automate-Write-Data-with-columns-na...

[momlo]

Hi @Try  

You need to write ColumnHeadersRow to your first row, it contains the names of the columns.

%ExcelData.ColumnHeadersRow%