Improvements to `RPA.Excel.Application` and `RPA.Browser.Selenium` libraries

Possible fix/workaround for Selenium on browser instances not being closed after the run (#1186). Change affects keywords RPA.Browser.Selenium.Open Available Browser and RPA.Browser.Selenium.Open Chrome Browser. Default behaviour can be changed by setting new parameter sandbox=True thus default Chromium argument --no-sandbox won't be set.
Improve RPA.Excel.Application.find() to allow selection of search_type (to search either within 'comments', 'values', 'comments' or 'comments threaded'), start_after (limit search area to be after this Range and exact (on True performs full match opposed to default partial match).
Improve RPA.Excel.Application.Open Workbook to allow loading workbooks from URLs.
Improve all RPA.*.Application.Quit Application keywords to perform garbage collecting before calling app.quit(), because otherwise exception can be triggered due to not all COM objects have not been released before app.quit().
Add rgb_to_excel_color(red, green, blue) method, which can be used to set suitable color for Excel Range.Font.Color and Range.Interior.Color

Example on opening URLs with RPA.Excel.Application library

# Open Robocorp course SalesData workbook
EXCEL.open_workbook("https://robotsparebinindustries.com/SalesData.xlsx")
results = lib.find("Name", search_type="values")
# Open workbook from Sharepoint
sharepoint_file_url = f"https://{SHAREPOINT_DOMAIN}.sharepoint.com/{SHAREPOINT_FOLDER_STRUCTURE}/test.xlsx"
EXCEL.open_workbook(sharepoint_file_url)

Example on formatting cells with RPA.Excel.Application library.

data_headers_range = EXCEL.get_range("data!A1:D1")
for dh_cell_range in data_headers_range:
    print(f"dh_cell_range .Address = {dh_cell_range.Address}")
    dh_cell_range.Font.Size = 32
    dh_cell_range.Font.Bold = True
    dh_cell_range.Interior.Color = rgb_to_excel_color(115, 147, 179)
data_headers_range.Columns.AutoFit()

Example on find improvements with RPA.Excel.Application library.

results = lib.find(
    "INVENTORY",
    search_type="values",
    exact=True,
    match_case=True,
)
if not results:
    print("Did not find INVENTORY cell")
else:
    search_after = results[0]
    print(f"INVENTORY CELL ADDR = {search_after.Address} VALUE = {search_after.Value}")
    results = lib.find(
        "QUANTITY",
        search_type="values",
        search_after=search_after,
        exact=True,
        match_case=True,
    )
    if not results:
        print("Did not find QUANTITY cell")
    for r in results:
        print(f"QUANTITY ADDR = {r.Address} VALUE = {r.Value}")

Example on browser workaround with RPA.Browser.Selenium library.


browser.open_available_browser(
    'https://robocorp.com/portal',
    browser_selection='Chrome',
    sandbox=True
)
# OR
browser.open_chrome_browser(
    'https://robocorp.com/portal',
    sandbox=True
)

robocorp / rpaframework

Improvements to `RPA.Excel.Application` and `RPA.Browser.Selenium` libraries #1191