Copy data

[sshitol (sush)]

Hi Team,

I need to copy sql query output to excel file. But the output of sql query coming in row, so same row i need to copy paste but while paste i need to paste data in the column wise not row wise in excel.

Regards,
sushant

[HareeshMR (Hareesh Madasi)]

@sshitol

But the output of sql query coming in row,

Are you using UiPath activities to execute the SQL query @sshitol?

Actually, if you use activities in UiPath, the output will be a data table. Can you elaborate your issue like where you are getting the row output?

[sshitol (sush)]

yes I am using uipath activity and the op is datatable. But datatable output is coming row. While pasting that row into excel, I want to paste that row as column in excel means horizontal to vertical copy pasting of data.

[HareeshMR (Hareesh Madasi)]

I’m confused with you explanation @sshitol

You want the value of each row to be pasted into the column of the excel?

[amaresan (Amaran)]

@sshitol

For Transpose row to column

Refer below post … it may help you

Transposing Excel Data Into a DataTable

Hi, use ReadRange activity in cycle and in each loop read one data set (ID,name, day, month) into a temp datatable calculate “range” dynamically, e.g. varRange = “A” + cstr(row) + “:B” + cstr(row+3) in each loop increment row by 4 to move to next data set, e.g. row = row + 4 append individual data sets from temp datatable to final datatable finish loop when reach end - temp datatable is empty Intentionally do not post complete workflow here as it would not help you to grow Cheers

[sshitol (sush)]

Yes right