Best Python code snippet using avocado_python
excel_helper.py
Source:excel_helper.py  
...14        if write:15            self._open_for_write(sheet_name)16        else:17            if sheet_name:18                self._open_for_read(f, content, sheet_name)19            else:20                self._open_for_read(f, content, sheet_number)21    def add_sheet(self, name, sheet_number):22        self.sheet = self.wb.add_sheet(name)23        self.sheet_number  = sheet_number24        self.x = 025        self.y = 026    def _open_for_read(self, f, content, sheet):27        if content:28            self.wb = xlrd.open_workbook(file_contents=content)29        else:30            self.wb = xlrd.open_workbook(f)31        if isinstance(sheet, basestring):32            self._goto_sheet(sheet_name=sheet)33        else:34            self._goto_sheet(int(sheet))35    def _open_for_write(self, sheet_name):36        self.wb = xlwt.Workbook(encoding='utf-8')37        self.sheet = self.wb.add_sheet(sheet_name) 38        self.sheet_number = 039        self.x = 140        self.y = 0...shortmagic.py
Source:shortmagic.py  
...25    def _write_command(self):26        command = input("Command: ")27        description = input("Description: ")28        return f"{command} {SEP} {description}\n"29    def _open_for_read(self, file):30        line_cache = []31        file_path = f"{DIR}/{getenv('SHORTCUT_DIR_NAME')}/{file}"32        with open(file_path, "r") as file:33            for line in file.readlines():34                try:35                    line_cache.append(line)36                except IndexError:37                    pass38        return line_cache39    def _open_for_append(self, file):40        file = f"{DIR}/{getenv('SHORTCUT_DIR_NAME')}/{file}"41        with open(file, "a") as file:42            file.write(self._write_command())43    def _open_for_clean_write(self, file, lines: None = list):44        file = f"{DIR}/{getenv('SHORTCUT_DIR_NAME')}/{file}"45        with open(file, "w") as file:46            file.writelines(lines)47    def _edit_file(self, file):48        coms = self._open_for_read(file)49        com_dict = {}50        for i in coms:51            k, v = i.split(SEP)52            com_dict[k.strip()] = v53            print(f"{k}   :   {v}")54        while True:55            k = input("Command to edit (typed exactly as seen): ").strip()56            if not com_dict.get(k):57                print("\ncommand is typed incorrectly or does not exist\n")58                continue59            com_dict.pop(k)60            newk, newv = self._write_command().split(SEP)61            com_dict[newk] = newv62            break63        scitems = [f"{k} {SEP} {v}" for k,v in com_dict.items()]64        self._open_for_clean_write(file, scitems)65# Custom ipython magic method documentation at: 66# https://ipython.readthedocs.io/en/stable/config/custommagics.html67@magics_class68class ShortMagic(ShortUtil, Magics):69    def __init__(self, *args, **kwargs):70        super().__init__(*args, **kwargs)71        self.apps = getenv("APPLICATIONS").split()72        self.scdir = DIR.joinpath(getenv("SHORTCUT_DIR_NAME"))73        self._create_files()74    @line_magic75    def sc(self, line):76        "Get a user defined list of IPython shortcuts"77        app = self._interpret_line(line, self.apps)78        if not app:79           return80        file = f"{app}.sct"81        coms = self._open_for_read(file)82        for i in coms:83            line = i.split(SEP)84            print(f"{line[0]}   :   {line[1]}")85    @line_magic86    def sc_add(self, line):87        "Add to IPython shortcuts file - ishortcuts.txt"88        app = self._interpret_line(line, self.apps)89        if not app:90           return91        file = f"{app}.sct"92        self._open_for_append(file)93    @line_magic94    def sc_edit(self,line):95        breakpoint()...Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Get 100 minutes of automation test minutes FREE!!
