My requirement is to fetch the cell value from excel sheet which contains a particular date Eg “P1” and then write a particular text to its adjacent Cell like “Q1”. I am able to fetch the cell value (“P1”) but don’t know how to increment it to “Q”. I tried “Char next_char = Convert.ToChar(Convert.ToUInt16(Input) +1)” but that is throwing error “Input String was not in correct format”.
HI,
Can you try the following expression? This support address like “AA1”, too.
UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnLetterToColumnIndex(System.Text.RegularExpressions.Regex.Match(strAddress,"^[A-Z]+").Value)+1)+System.Text.RegularExpressions.Regex.Match(strAddress,"\d$").Value
Regards,
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.