Some of the values will not write correctly

[helpplease]

Hello, the value in blue cells will not write although i have already specify the range in the Lookup Range activity. It’s definitely something to do with the Write Cell activity because when i write line the “excelRange” after the Lookup Range activity, it looked up correctly.

^the value 238.8 should appear in cell AC6 of the column Feb '23 and value 81 should appear in cell AD6 of the column Mar '23. But there’s nothing there. The rest of the values are able to write into the correct cell as shown for Nov '22.

^those 2 values will write into A1 instead. It shows 238.8 because it overwrite 81.

[Anil_G (Anil Gorthi)]

@helpplease

Can you please elaborate what is not nor working and what you tried

Cheers

[helpplease]

I think my expression in the write cell activity caused the issue. I’ve edited more on what happened

[helpplease]

Hi, is any one avaliable to help me please?

[Yoichi]

Hi,

I think it should be as the following.

System.Text.RegularExpressions.Regex.Match(excelRange,"^[A-Za-z]+").Value+"6"

If index is string variable which has row offset, the following will work.

System.Text.RegularExpressions.Regex.Match(excelRange,"^[A-Za-z]+").Value+(CInt(index)+6).ToString()

Regards,

[supermanPunch (Arpan)]

Hi @helpplease ,

We would ask you to check on the values of the variables excelRange and index. Do also post them here.

This would help us further on providing proper suggestions.