Import CSV object with Semicolon delimiter (MS Excel VBO)

[KashishJain]

Hi,

I am using MS Excel VBO - Import CSV Action to get csv into excel. The CSV has semicolon separated values so i changed the the code to this :

There are no errors in the object but when I run the code it says : The given key was not present in the dictionary and fails.

Can anybody help me with this ? Or have any other solution for this ?

------------------------------
Kashish Jain
RPA Developer
Schneider Electric
------------------------------

[KashishJain]

Hey Mitsuko,

This worked for me. Thanks for the support 🙂


------------------------------
Kashish Jain
Application Engineer
Schneider Electric
------------------------------

[RageLiberato]

Hi @KashishJain,

How did you make it work? did you save or target the text replaced? I tried both and its not working​

------------------------------
Rage Liberato
------------------------------