Method
The `load_workbook` function can be used to open an existing workbook file. The function’s syntax is:
wb=openpyxl.load_workbook(filename,read_only,keep_vba,guess_types, data_only,keep_links)
Where:
`filename` — a string representing the file path and name of the file to be opened.
`read_only` — a boolean indicating read-only mode. Setting it to read-only helps save memory for large files.
`keep_vba` — a boolean for files with VBA macros. If True, it retains the VBA code.
`guess_types` — a boolean that determines whether to guess data types when reading data from the worksheet.
`data_only` — a boolean specifying whether to display the most recent calculation results in cells containing formulas.
`keep_links` — a boolean indicating whether to preserve external links.
This function returns a workbook object.
Sample Code
#Opening an Existing Workbook
#Import the load_workbook function
from openpyxl import load_workbook
#Load an existing workbook file
wb=load_workbook('test.xlsx')