Problem with write cell excel formula

janwillem1 · August 27, 2021, 9:01am

Hi,

I want to get the weeknumbers from an excel column with dates.
For this I have a Write cell activity in a For each excel row with the formula: “=Weeknumber(A1)”

The robot writes this as “=@week number(a1)”, excel displays this as #name.
Only when I click on the cell is the formula recognized and calculated.

What do I need to do to run the formula immediately?

Gresilda_Balla · August 27, 2021, 9:52am

Hi @janwillem1
Try using the Excel not the Workbook activities

Gresilda_Balla · August 27, 2021, 9:54am

ermanoj3101 · August 27, 2021, 5:44pm

Hi @janwillem1 ,

Try to use below code and let me know if you face any issue.

WriteFormula.xaml (6.1 KB)

Make sure below package is installed

Topic		Replies	Views
How to input excel formula into excel cell from write cell activity Activities excel , activities , studio , question , activities_panel	5	490	July 6, 2023
Get Date from Week number Help	19	1983	August 21, 2019
Update formula in excel - #name? Studio studio , question , activities_panel	4	1004	April 6, 2021
Excel - Write Cell Assitance StudioX excel , uiautomation , question	4	470	April 29, 2023
Excel after header A and B write a formula Studio	5	1420	May 3, 2021

Problem with write cell excel formula

Related topics