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.
got through the below loop
can i see your xaml.Theres a lot of way how to add column … you can add in datatable or in excel it self…
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.
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 ?
This is my CSV file i want to write data on L1 Column.
pubmed_result.zip (232.8 KB)
Refer this post to add column into specific position.
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 ?
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.
PubMed.xlsx (109.5 KB)
This the data i am trying to write in csv column.
Thank you very much in advance
Kindly see the attachment for your reference. Hope this might be helpful to you
pubmed_result_Test - Copy.zip (800.3 KB)
Thank You Very Much
Your most welcome @sneha_arbole
Happy to help here
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.