Excel "Insert Column" activity throws an error

[Mach82]

Hello,

When I use Excel “Add column” activity, the column will be added, but I will receive the error as below.
I use Polish Windows 10 version and Office 365 in English
General format will fail.
Numeric format will fail if I use 1 or more decimals.
Percentage format will fail if I use 1 or more decimals.
Time and date formats work fine.
Custom format 0,00 works fine but 0.00 will fail.

If I switch Windows version to English, I will not get errors (decimal symbol changes from , to .)

I want to keep Polish Windows version and “,” as decimal symbol. Can you fix the Excel “Add column” activity?

StudioX 2021.10.7, excel activities 2.16.0 (but it didn’t work with earlier versions of excel activities)

[Raluca_Laic]

Hi @Mach82 ,

We’re currently looking into this and investigating this further. We’ll update you here once we have further details.

Thanks,
Raluca

[Sorin_Constantin]

Hello @Mach82 ,

Please verify if Use system separators setting from Excel is checked, if not, you should check it.
You can find it following the instructions described here:
Change the character used to separate thousands or decimals - Microsoft Support

If the problem is still reproducing, please write us back.

Thanks,
Sorin

[Mach82]

Hi,

I’m replying to confirm, that once I deselect using the system separators in excel, the automation runs without throwing any errors.

Thank You so much for helping me out.