To write into excel after if activity

Help
1

hey everyone. I’m still trying to figure out how to get the bot to write to the correct cell.currently it is only writing to row 2 or 3 sometimes.

overview of my sequence is:

1.excel scope
2.for each (to get different sheets in excel)
3. Read range
3.for each row in data table
4. if activity that check if status is New
5. write cell
6. attach files into browser

I need to update the spreadsheet such that if the status is “new”, bot to update under the column “remarks” on that specific row.

15578817841798157500625421944845
155788178417981575006254219448452736×3648 2.05 MB

2

Hey @Popo

Just Go through with below sample and let me know :slight_smile:

WriteCellSample.xaml (9.1 KB)

Regards…!!
Aksh

3

hey @aksh1yadav

is it a must to build datatable before we can write cell?

possible to screenshot the sequence as I have issues opening the xaml file

4

Hey @Popo

No you can just read your excel that will return you datatable.

i just used for sample data. :slight_smile:

Regards…!!
Aksh

5

is it possible to screenshot the sequence u sent in xaml file? I have issue reading it

6

Hey @Popo

Sure but just upgrade your package dependency it will work for you.

image

Regards…!!
Aksh

7

Hey @Popo

Please find below attached sample workflow which will update Remarks column value to OK based on Status column value.

ExcelUpdate.zip (16.4 KB)

Regards,
Vijay.

8

hi @Vijay_Kumar_C

possible to screenshot the sequence as I have issues reading it pls.

9

Hey @Popo

Why not :slight_smile: please find below image.

Excel%20Application%20Scope
Excel%20Application%20Scope669×973 62.4 KB

Regards,
Vijay.

1 Like
10

hi @Vijay_Kumar_C

there will be a error under write range that states datatable cannot convert to string.

I added . to string but the bot doesn’t write into excel

11

Hi @Popo

Please share your flow. i will check and do modification.

Regards,
Vijay.

12

hi @Vijay_Kumar_C

I have pm-Ed u. thanks!

13

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