raise ValueError("More than 4094 XFs (styles)")
ValueError: More than 4094 XFs (styles)

Using various XML methods to parse untrusted XML data is known to be vulnerable to XML attacks. Using the defusedxml module is recommended. Methods should be replaced with their defusedxml equivalents.

Accessing a protected member (a member prefixed with _) of a class from outside that class is not recommended, since the creator of that class did not intend this member to be exposed. If accesing this attribute outside of the class is absolutely needed, refactor it such that it becomes part of the public interface of the class.

While trying to access any url, the following message gets printed on the console.

C:\Users\AppData\Local\Programs\Python\Python36-32\lib\site-packages\urllib3\connectionpool.py:847: InsecureRequestWarning: Unverified HTTPS request is being made. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#ssl-warnings
InsecureRequestWarning)

writefile.py
A module has been imported but is not used anywhere in the file. The module should either be used or the import should be removed.

writefile.py
Imports from different modules should be on different lines.

import os, sys # multiple imports on same line

instead these imports should be on their own line

import os
import sys

In code, while trying to update the excel after around 4K th line, the following error occurred

raise ValueError("More than 4094 XFs (styles)")
ValueError: More than 4094 XFs (styles)

It is recommended to follow the Python naming convention while naming things.

Local variable name hides the variable defined in the outer space, making it inaccesible. It may cause confusion.

Local variable name hides the variable defined in the outer space, making it inaccesible. It may cause confusion.

A module is reimported mulitple times. This can be confusing, and should be fixed.

Encryption in general is typically critical to the security of many applications. Using TLS can greatly increase security by guaranteeing the identity of the party you are communicating with. This is accomplished by one or both parties presenting trusted certificates during the connection initialization phase of TLS.

Even after using

try:
    _create_unverified_https_context = ssl._create_unverified_context
except AttributeError:
    # Legacy Python that doesn't verify HTTPS certificates by default
    pass
else:
    # Handle target environment that doesn't support HTTPS verification
    ssl._create_default_https_context = _create_unverified_https_context

#To ignore Http Errors/SSL Error
if (not os.environ.get('PYTHONHTTPSVERIFY', '') and
    getattr(ssl, '_create_unverified_context', None)): 
    ssl._create_default_https_context = ssl._create_unverified_context

SSL certificate error occurs

Indentation has has both tabs and spaces in it. You should use either tabs or spaces, but not both.

block comment should start with ‘# ‘

FLK-E265