Variables and Excel

[frederic-f.bonnet]

Hi ,

I ve got a problem with studio , i try to create some variables coming from an Excel Export , but the software said me

Assign : DEV_NUM: Le format de la chaîne d’entrée est incorrect.
Assign : DEV_NUM: The format of the input string is incorrect.

DEV_NUM = CurrentRow.ByField(String.Format(“}Référence Affaire”, vbLf, vbCr))

Reference affaire is the name of column in the excel export

Could you help me , i m beginner on Studio . Thanks

[sarathi125 (Parthasarathi)]

@frederic-f.bonnet,

Not clear what exactly you are trying, If you need to create variable in studio with the name coming from Excel file, then I don’t think that is possible.

If you want to hold the values from the excel then create string variable in studio and use them to hold the values.

[frederic-f.bonnet]

Ok ,

In fact I discovered by chance, the answer, in the case that I expose I reused a part of a robot which was created on studio x, when I converted all to the studio format I had to modify some variables, it seems that the change of variables between studio X and studio is not a good idea because the variables created under studio x have probably specific environment or format , if they are modified under studio, they do not function at all.

Under studio x :
CurrentRow.ByField(String.Format(“}Référence Affaire”, vbLf, vbCr))

Under studio :
CurrentRow(“Référence Affaire”).ToString

I don’t have anorther explanation for it