Writing data into excel column based

excel
activities

#1

I need to read a row from excel sheet/database query and copy the data into another excel vertically( read rows in database table/excel and in new excel it should be copied in vertical style)

How can i achieve this using UI path? Please do suggest on this

Thanks,
Vishal Kumar


#2

@certified


#3

Any Inputs on how to do this ??


#4

Convert the excel into datatable. Then use datatable.select(Condition) to set into DataRow[].
Use for each loop to get individual row


#5

Hi Bikash,

I am new to UI path. Can you please creare a sample project and share a dummy xaml file for this

Thanks,
Vishal Kumar


#6

To be clear on the requirement, I have the input as

image

and I need the output as

image


#7

Main.xaml (23.7 KB)

Please find the attachment. It contains a sample to copy from excel to datatable. it contains some other functionalities as well like datatable.clone .


#8

Hi Bikash,

I think the solution you shared will not work for the requirement. Please correct me if I am wrong. I hope you are clear on the requirement. Please let me know if you need any further information

Thanks,
Vishal Kumar


#9

I guess you want to transpose the datatable. please find my xaml below. You can find the code after the log message “Transpose” where Datatable has been converted into transposed Datatable.Main.xaml (38.3 KB)


#10

Transform Excel Data.zip (9.3 KB)
Hi Vishal,

Please check the attached code…
I hope it will be helpful to you.

Please let me know if you need any more help regarding this

Thanks,
Kumar