Storing column widths in a variable (when variable is in a config file)

Hello,

I am performing the generate data table activity and I would like to store the column widths in a variable within a config file. I have been able to do this successfully using the variables table within the workflow but when it is stored in a config file it fails because it requires the variable type to be system int 32 rather than just simply int 32. Is it possible to read a system int 32 variable from a config file?

Thanks,

Isabelle

CInt(YourConfig(YourKey).ToString.Trim)

Hi @qaautomation

You can convert the string into Int 32 using below statements:

Convert.ToInt32(Config(“key_Name”).ToString.Trim)

OR

CInt(Config(“key_Name”).ToString.Trim)

The value that should be in the column sizes is this: {6,16,5,6,65}. I populated in the config file as instructed but when I entered the statement you put above and there is a compiling error.

I think it’s because the column width should be a System.Int32 variable type not just a int32 which throws the compiling error.

your inital description differs from

we will split

have a look here:
grafik

just store the string without { } within the excel

Can you provide more detail like a screenshot? I am not following completely.

was done within immediate panel. You can also explore at your end:

later you can model it with assign activities or use within the activities

This worked! Thank you. Providing more detail if other users are following along.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.