For Each Row Increment Write Cell

Hello,

I have an excel sheet with Company names that i am updating with an additional Company name column with modified data. Currently when i run the process it only writes the last company name in the first cell.

Austria.xaml (23.7 KB)

Austria.xlsx (13.7 KB)

@jon1302
Buddy can i have a full solution a a zipped one as there is some issue in opening the xaml in my studio, its easy buddy we can sort this out easily

cheers …!

Austria.zip (13.3 KB)

Try this :slight_smile:

Buddy the json file is missing in the zip so unable to see some activities,kindly can you zip them all together send once…
Sorry for the inconvenience

Cheers…

@Palaniyappan

Sorry! Try this

project.zip (11.1 KB)

HI @jon1302

I don’t see any activities in your solution… :slight_smile:

1 Like

I am unable to see any process buddy…

image

@jon1302

Kindly resend the file once buddy

Cheers…!

1 Like

@Palaniyappan @Lahiru.Fernando

Sorry both, should have it this time :smiley:

project.zip (13.8 KB)

@jon1302
Buddy I think you are going good, its working correctly see buddy as you expect, the additional company name column is getting entered to its column not the first cell,but its getting entered in new column name column name 2 as you have use add data column.

Actually you got the output buddy, just i changed the sheet name from Results to Sheet2

Hope this would help you

Cheers…

1 Like

@Palaniyappan

Apologies i had added in a write range to test the data table. I’ve modified the files and uploaded again. I wanted to see if it was possible to update to original ‘Results’ tab in the Austria file.

project.zip (13.9 KB)

Buddy @jon1302

Its resolved buddy, just kept the write cell in for each row - update itself
Here is your xaml
Austria.xaml (24.1 KB)

Cheers…

1 Like

Is that working buddy…
@jon1302

Yea perfect! :slight_smile: sorry for the late reply only just logged back in.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.