How to get Column Address from column Name in Excel ? – User friendly Tech help
Requirement:-To find the Address of given Column in Excel. nnIn the below image we need to find the Address of “Application” column in the excel.Which is “C”.nn n n n n n Excel Data n n n nCode:- n sSheetName = “uftHelp”sColumnName = “Application”sPath = “C:TempTest.xlsx”fnExcelColAddress sSheetName,sColumnName,sPath’*******************************************Function***********************************’Function Name:- fnExcelColAddress’Function Description:- Fetch the Excel Column Address based…