Excel manipulation: setCellType, Style, setForceFormulaRecalculation

please, I face some issues when I try to copy a sheet1 from an excel_file_1 to another one (sheet2 of excel_file2), in fact, the copy/or set of the cell type or style doesn’t work.
Even when I change the type of the cell I obtain the numbers as Strings (see the green triangle in the screenshot) also Time cells are not in the right form. So to make “setForceFormulaRecalculation” on my cells which contains formulas I have to set my excel sheet manually.
could you please help me to make it automatically?

Hello @samehcherif,

Did you copy Excel sheet via Actions flow? Did you face the same issue when you copied it manually?


no via excel methods (even i tried to use the script in this link also: “https://kb.workfusion.com/display/RPA/Excel+Class”), and when i copy it manually i didn’t face any issue.
thanks for your reply.