I have the following situation:
I have an Excel file with 2 columns:
From another file I read data for B and C column.
On Column B I have dates like 2/25/2021.
On Column A I have a formula =Text(B1, “MMMM”) // should return the name of the month - February.
My workflow is like this:
dtSource = readRange from source file;
writeRange on col B,C in destination file; // writes all data on col B and C
assign colAFormula ="=Text(B1, ““Mmmm””)";
buildDataTable (Culmn A as string) as tempTable
addDataRow activity colAFormula to tempTable;
writeRange A1 tempTable;
autofill A1:A1 as Source => A1:A100 as destination;
when I run the project from uipath studio it works fine; on Column A I have January;
when I run the project from the orchestrator on Column A I have number 100 instead of January.
Does anyone have any suggestion?