Jun-27-2021, 07:58 PM
Hi, is it possible to read and write an active Excel workbook? All I have found so far, is either create a new Excel and write inn, or provide a path to an Excel file, and then read / write (but the file needs to be closed before the script runs, otherwise it will fail). I hope there are some ways to work with an active Excel file?
from openpyxl import Workbook wb = Workbook() # creates a new Excel wb_obj = openpyxl.load_workbook(path) # or load an Excel with a path