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
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.
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
Hi I have a doubt with the same kind of… I already have a datatable dt1 (only 1 row will be having). using dt1… I am getting 2 values by doing some math where I have to add it to dt1 itself… On the other hand I need dt1 (1st row + current row). Any help would be appreciated
Hi Yosefgunawan, try to use Write Range (workbook) activity and in the properties panel use the Add Header option checked. That way your row 1 is never replaced. Else try to start from “A2” and that you can use a counter as well. For example “A”+Counter.ToString.
Set the counter initial value to 2 and then write assign - (Counter = Counter +1)