Newer
Older
istex-enrich-monitoring / script / excel-refresher / excel-refresher.py
@Mathis EON Mathis EON on 18 Jun 2024 303 bytes wip
import openpyxl

# Load the Excel file
workbook = openpyxl.load_workbook("../../excel/erichments.xlsx")

# Refresh all data connections in the workbook
for connection in workbook.connections:
    connection.refresh()

# Save the updated workbook
workbook.save("../../excel/erichments2.xlsx")