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…

How to log a Bug in ALM using OTA? – User friendly Tech help

Requirement: – Logging Bug in ALM/QC programmatically, without any manual intervention. n Solution: – We will utilize the capabilities of OTA (Open Test Architecture) of ALM to log a Bug. n Approach: – Key is “TDConnection object” which is the entry point for using OTA; with this object we can access most of the functionalities…

Setup for Robot Framework Automation – User friendly Tech help

World changes constantly..nWe change each day..nOnce U find itself U have to begin again.nnToday we are changing and learning Robot Framework and thought of sharing the same with others co-learners, please add your expertise as comments to this post. We have already shared our posts on established automation tools like UFT and Selenium.nnDo follow us…

Apex Superbadge (part-1) – User friendly Tech help

n Scenario:- Automate record creation n n Install the unmanaged package for the schema and stubs for Apex classes and triggers. Rename cases and products to match the HowWeRoll schema, and assign all profiles to the custom HowWeRoll page layouts for those objects. Use the included package content to automatically create a Routine Maintenance request…