brings up the developer tools in chrome pressing ctrlshift- (on windows and linuxor option- (on os xbrings up the developer tools in firefox right-click the element in the page and select inspect element from the menu '#main highlight 'div div 'button[value="favorite"] spam gettext( linkelem attrs the selenium module is imported with from selenium import webdriver the find_element_methods return the first matching element as webelement object the find_elements_methods return list of all matching elements as webelement objects the click(and send_keys(methods simulate mouse clicks and keyboard keysrespectively calling the submit(method on any element within form submits the form the forward()back()and refresh(webdriver object methods simulate these browser buttons the openpyxl load_workbook(function returns workbook object the sheetnames attribute contains worksheet object run wb['sheet 'use wb active sheet[' 'value or sheet cell(row= column= value sheet[' ''helloor sheet cell(row= column= value 'hellocell row and cell column they hold the highest column and row with values in the sheetrespectivelyas integer values openpyxl cell column_index_from_string(' ' openpyxl cell get_column_letter( sheet[' ':' ' wb save('example xlsx' formula is set the same way as any value set the cell' value attribute to string of the formula text remember that formulas begin with the sign when calling load_workbook()pass true for the data_only keyword argument appendix