Hi,
I was trying to insert a formula in excel facing unexpected special character adding in it. Please guide me to figure this out. attached the screenshot.
after executed the code, from excel its like
i didt provide “@” in formula but its presented after executed the code.
Anil_G
(Anil Gorthi)
October 31, 2023, 11:41am
2
@srinivasanma1
Formula cannot be used in workbook activities please use write cell in excel activities…that should solve the issue
cheers
Nope, again the same issue.
still the same
lrtetala
(Lakshman Reddy)
October 31, 2023, 11:51am
4
Hi @srinivasanma1
Could you please try it in manually in excel is it working?
Anil_G
(Anil Gorthi)
October 31, 2023, 11:52am
5
@srinivasanma1
Can you try using modern excel activities…also please confirm your excel package version and excel version…as there was one old reported bug…
try to change the excel version higher also might help
Just to loop back, this issue is fixed by using the Modern Excel activities.
cheers
Yeah i did it, Yes its working while checking by manually but while executed with activity its getting change
lrtetala
(Lakshman Reddy)
October 31, 2023, 11:59am
7
@srinivasanma1
As @Anil_G suggested could you please with Modern Excel Activities
Anil_G
(Anil Gorthi)
October 31, 2023, 12:02pm
8
@srinivasanma1
Please try with modern if you have access or try to upgrade excel activities to latest and check as there is a reported bug already in classic, which is not fixed as of Apr 22
cheers
Thanks to all, its working with Modern activities.
1 Like
system
(system)
Closed
November 3, 2023, 1:02pm
10
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.