How to add data row without replace the first row? How to make it continue?

activities

#1

Hi Everyone…
I got a problem here about Data Table. The case is i try to copy a text from a page and add it to row with “add data row” and directly i add it to csv. And i do the same thing with same variable, but the result is it always replace the first row, that is’nt continue. If exist, Hopely you can share a file xml for more helpful :slight_smile:

Thanks.


#2

@yosefgunawan
make sure you are appending to csv, not writing to csv…


#3

Hi @AkshaySandhu … Thanks for your response :slight_smile:
I try to append to csv too, but it still same …


#4

please upload your xaml file…


#5

Hi @yosefgunawan

You can use append to CSV or append Range after writing range to the same Excel sheet. Append Range works if you are using Excel application scope earlier and then writing and appending it.

I have used Append Range below after writing it, so that it will continue from the next row:


#6

Hi @AkshaySandhu maybe there are which will u see in my project. I try to get 2 data, but it always replaced…



#7

Hi @sonesh.bansal
Thanks for your response :slight_smile:
Is it making csv file? maybe u have an example in xml form that can u share here … Btw Thanks :slight_smile:


#8

hello @yosefgunawan

Main.xaml (13.5 KB)

let us know if this helps you to build the logic for your process…


#9

Hi @yosefgunawan,

Please find xaml below. It is reading the content from excel, building data table, iterating through each row in the build data table getting row items, adding data row , writing and appending to CSV. It is working great and this workflow also contains filter data table activities which I have commented out, you can also practice that.

Note: Change the path of the excel and CSV which you want to use from your desktop

Forum Practise 1.xaml (17.9 KB)

I hope it clears everything, please let me know if you have any questions


#10

Hi @AkshaySandhu
It Fixed, Thanks a lot :slight_smile:


#11

Hi @sonesh.bansal
It Fixed, Thanks a lot :slight_smile: