Skip to content

Instantly share code, notes, and snippets.

View RyanMDavies7's full-sized avatar

Ryan Davies RyanMDavies7

View GitHub Profile
@RyanMDavies7
RyanMDavies7 / Automatic Excel Updater (Python)
Last active September 13, 2022 08:29
Python Code that Automatically Updates Excel Spreadsheets
# It is recommended that you extract your username, password and database variables from an external file rather than having them directly within your code else you maybe exposed
username = "#"
password = "#"
database = "database:port /servicename"
directory = r'#:\...\file.xlsx'
SQL = """SELECT * FROM Table"""