Write excel file row wise

Do anybody tell me how to write excel file row wise from a data table column? Write range is only working column wise data fetching.

Did you try to use for each activity with Write cell inside it?

It sounds like there is no data in your datatable. Is it a datatable that was built using the “Build Data Table” activity? By default that would have a blank row and you’d see only the column headers.