Hello,
I am trying to add Column on specific position in CSV(Column L1) and add data from excel. I tried using Add Data Column but it is adding on 1st position.
can i see your xaml.Theres a lot of way how to add column … you can add in datatable or in excel it self…
cheers
Happy learning
the main data is in CSV format…can i add the extracted data in CSV File directly on specific column?
Ok lets create a scenario.
Scenario
1.You read the csv file using Read CSV Activities.
2.It will return a Datatable ?
3.The return datatable will be writen in excel Using Excel applcation scope and Write Range?
4.Question how do you want to write the additional colum ?
cheers
Happy learning
Yes i want it after properties Coumn
Do you have any specific value to write or do you want me to create dummy date to be written in the additional column ?
@sneha_arbole
cheers
Happy learning
i have specific data which is string format.
1.I can use foreach row to modify the excel if you have string format.I just need to know what is the format of your string so that i can create a logic on it on how to apply it in our process.
2.I can easily input colection of data to add in our new column in our dattable like this.
cheers
Happy learning
PubMed.xlsx (109.5 KB)
This the data i am trying to write in csv column.
Thank you very much in advance
Hi @sneha_arbole
Kindly see the attachment for your reference. Hope this might be helpful to you
pubmed_result_Test - Copy.zip (800.3 KB)
cheers
Happy learning
Thank You Very Much
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.