Create excel Table with Dynamic datas - "@" character issue

Help Studio
2

Hi,

If Colcount is 27, Convert.ToChar(Convert.ToUInt32("A"C)+Colcount-1) will return not "@" but "[".
Can you share your expressions after the above?

Or, I recommend to use UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter method.
This returns column letter from R1C1 style column index.
For example UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(27) returns "AA"

Regards,

1 Like