ap.mouse_click()

x=” “, y=” “, left_or_right=”left”, no_of_clicks=1, type_of_movement=”abs”

Clicks at the given X Y Co-ordinates on the screen using ingle / double / triple click(s). Has an optional argument for which type of movement will take place where values can will be “abs” (default) or it can be”rel”

ap.mouse_move()

x=” “, y=” “, type_of_movement=”abs”

Moves the cursor to the given X Y Co-ordinates. Has an optional argument for which type of movement will take place where values can will be “abs” (default) or it can be”rel”.

ap.mouse_drag_from_to()

x1=” “, y1=” “, x2=” “,y2=” “

Clicks and drags from X1 Y1 co-ordinates to X2 Y2 Co-ordinates on the screen

ap.mouse_search_snip_return_coordinates_x_y()

img=” “, wait=180

Searches the given image on the screen and returns its center of X Y co-ordinates.

ap.window_show_desktop()

None

Minimizes all the applications and shows Desktop.

ap.window_get_all_opened_titles_windows()

None

Gives the title of all the existing (open) windows.

ap.window_activate_and_maximize_windows()

windowName=” “

Activates and maximizes the desired window.

ap.window_minimize_windows()

windowName=” “

Activates and minimizes the desired window.

ap.window_close_windows()

windowName=” “

Close the desired window.

ap.windows_launch_app()

pathOfExeFile=” “

Launches any exe or batch file or excel file etc.

ap.window_get_active_window()

None

Gives the title of the current active window

ap.window_activate_window()

window_title=” “

Activates the window with the given name.

ap.folder_read_text_file()

txt_file_path=” “

Reads from a given text file and returns entire contents as a single list

ap.folder_write_text_file()

txt_file_path=” “, contents=” “

Writes given contents to a text file

ap.folder_create()

strFolderPath=” “

When you are making leaf directory, if any intermediate-level directory is missing, folder_create() method creates them.

ap.folder_create_text_file()

textFolderPath=” “, txtFileName=” “

Creates text file in the given path.

ap.folder_get_all_filenames_as_list()

strFolderPath=” “, extension=’all’

Get all the files of the given folder in a list.

ap.folder_delete_all_files()

fullPathOfTheFolder=” “, file_extension_without_dot=”all”

Deletes all the files of the given folder

ap.file_rename()

old_file_path=’’, new_file_name=’’, ext=False

Renames the given file name to new file name with same extension.

ap.file_get_json_details()

path_of_json_file=’’, section=’’

Returns all the details of the given section in a dictionary

ap.key_hit_enter()

write_to_window=” “

Enter key will be pressed once.

ap.key_press()

key_1=’’, key_2=’’, key_3=’’, write_to_window=” “

Emulates the given keystrokes.

ap.key_write_enter()

text_to_write=” “, write_to_window=” “, delay_after_typing=1, key=”e”

Writes/Types the given text and press enter (by default) or tab key.

ap.scrape_save_contents_to_notepad()

folderPathToSaveTheNotepad=” “, switch_to_window=” “,X=0, Y=0

Copy pastes all the available text on the screen to notepad and saves it.

ap.scrape_get_contents_by_search_copy_paste()

highlightText=” “

Gets the focus on the screen by searching given text using crtl+f and performs copy/paste of all data. Useful in Citrix applications. This is useful in Citrix applications

ap.screen_clear_search()

delay=0.2

Clears previously found text (crtl+f highlight)

ap.search_highlight_tab_enter_open()

searchText=” “, hitEnterKey=”Yes”, shift_tab=’No’

Searches for a text on screen using crtl+f and hits enter. This function is useful in Citrix environment.

ap.find_text_on_screen()

searchText=” “, delay=0.1, occurance=1, isSearchToBeCleared=False

Clears previous search and finds the provided text on screen.

driver = ap.ChromeBrowser()

None

To initialise a ChromeBrowser class.

driver.open_browser()

url=” “, dummy_browser=True, incognito=False, profile=”Default”

Function to launch browser and start the session.

driver.navigate()

url=” “

Navigates to Specified URL.

driver.write()

Value=” “, User_Visible_Text_Element=” “

Write a string on the given element.

driver.mouse_click()

User_Visible_Text_Element=” “, element=” “, double_click=False, right_click=False

Click on the given element.

driver.browser_locate_element_h()

selector=” “, get_text=False, multiple_elements=False

Find the element by Xpath, id or css selection.

driver.wait_until()

text=” “, element=”t”

Wait until a specific element is found.

driver.refresh_page()

None

Refresh the page.

driver.close()

None

Close the Helium browser.

driver.hit_enter()

None

Hits enter KEY using Browser Helium Functions

driver.key_press()

key_1=” “, key_2=” “

Type text using Browser Helium Functions and press hot keys

driver.mouse_hover()

User_Visible_Text_Element=” “

Performs a Mouse Hover over the Given User Visible Text Element

driver.scroll()

direction=”down”, weight=”100” px

Scrolls the browser window.

ap.string_remove_special_characters()

inputStr=” “

Removes all the special character.

ap.string_extract_only_alphabets()

inputString=” “

Returns only alphabets from given input string

ap.string_extract_only_numbers()

inputString=” “

Returns only numbers from given input string

ap.excel_get_all_sheet_names()

excelFilePath=” “

Gives you all names of the sheets in the given excel sheet.

ap.excel_create_excel_file_in_given_folder()

fullPathToTheFolder=” “, excelFileName=” “, sheet_name=”Sheet1”

Creates an excel file in the desired folder with desired filename

ap.excel_if_value_exists()

excel_path=” “, sheet_name=”Sheet1”, header=0, usecols=” “, value=” “

Check if a given value exists in given excel. Returns True / False

ap.excel_copy_paste_range_from_to_sheet()

excel_path=” “, sheet_name=”Sheet1”, startCol=0, startRow=0, endCol=0, endRow=0, copiedData=” “

Pastes the copied data in specific range of the given excel sheet.

ap.excel_get_row_column_count()

excel_path=” “, sheet_name=”Sheet1”, header=0

Gets the row and column count of the provided excel sheet.

ap.excel_copy_range_from_sheet()

excel_path=” “, sheet_name=”Sheet1”, startCol=0, startRow=0, endCol=0, endRow=0

Copies the specific range from the provided excel sheet and returns copied data as a list

ap.excel_split_by_column()

excel_path=” “, sheet_name=”Sheet1”, header=0, columnName=” “

Splits the excel file by Column Name

ap.excel_split_the_file_on_row_count()

excel_path=” “, sheet_name = “Sheet1”, rowSplitLimit=” “, outputFolderPath=” “, outputTemplateFileName =”Split”

Splits the excel file as per given row limit

ap.excel_merge_all_files()

input_folder_path=” “, output_folder_path=” “

Merges all the excel files in the given folder

ap.excel_drop_columns()

excel_path=” “, sheet_name=”Sheet1”, header=0, columnsToBeDropped = “ “

Drops the desired column from the given excel file

ap.excel_clear_sheet()

excel_path=” “,sheet_name=”Sheet1”, header=0

Clears the contents of given excel files keeping header row intact

ap.excel_set_single_cell()

excel_path=” “, sheet_name=”Sheet1”, header=0, columnName=” “, cellNumber=0, setText=” “

Writes the given text to the desired column/cell number for the given excel file

ap.excel_get_single_cell()

excel_path=” “,sheet_name=”Sheet1”, header=0, columnName=” “,cellNumber=0

Gets the text from the desired column/cell number of the given excel file

ap.excel_remove_duplicates()

excel_path=” “,sheet_name=”Sheet1”, header=0, columnName=” “, saveResultsInSameExcel=True, which_one_to_keep=”first”

Drops the duplicates from the desired Column of the given excel file

ap.excel_get_all_header_columns()

excel_path=” “,sheet_name=”Sheet1”,header=0

Gives you all column header names of the given excel sheet

ap.excel_describe_data()

excel_path=” “,sheet_name=”Sheet1”,header=0 | Describe statistical data for the given excel

ap.isNaN()

value | Returns TRUE if a given value is NaN False otherwise

ap.excel_to_colored_html()

formatted_excel_path=” “

Converts given Excel to HTML preserving the Excel format and saves in same folder as .html

ap.clear_screen()

None

Clears Python Interpreter Terminal Window Screen

ap.print_with_magic_color()

strMsg:str=” “, magic:bool=False

Function to color and format terminal output

ap.show_emoji()

strInput=” “

Function which prints Emojis

ap.download_this_file()

url=” “

Downloads a given url file to BOT output folder or Browser’s Download folder

ap.pause_program()

seconds=”5”

Stops the program for given seconds