Help with filling in columns in excel

[HENG_JUN_YING_AARON]

Hello, I need some help here.

What I want to do is to fill up my data which I extracted by columns using the for each function, however when I do so it goes down the row instead.

What I want it to be.

This is the part on writing into the excel, I have no problems with extracting the data.

[Anil_G (Anil Gorthi)]

@HENG_JUN_YING_AARON

If you want to change the column then you need to change or make dynamic the Q value and not the number after Q

use the same approach on index…but instead of using index value for number after Q use it to change Q

so your cell value would be UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(index + 17) + "3"

here assumption is your index starts from 0 so added 17 which represents Q…and row value I used is 3…

Hope this helps

cheers

[HENG_JUN_YING_AARON]

Thank you Anil you have solved my issue, I was just wondering if my assign activity was actually needed and if so what is its purpose?

Cheers

[Anil_G (Anil Gorthi)]

@HENG_JUN_YING_AARON

Glad it resolved your issue!!

Are you in a loop?

if yes then your assign is incrementing your index…

but the same increment can directly be taken from For loop properties…you would have an index property to which you can assign a variable as needed

cheers

[HENG_JUN_YING_AARON]

Ahh, I see

Well either way, you have solved my issue and I will mark it as solved!

Thanks so much for your help once again!