pycel_excel_workbook_to_python_graph_cell_evaluation.py

1from pycel import ExcelCompiler
2
3# Path to your excel file
4filename = "example.xlsx"
5
6# Load the workbook and compile it into a graph
7excel = ExcelCompiler(filename)
8
9# Evaluate a specific cell (e.g., Sheet1 cell A3)
10# pycel uses a 'SheetName!CellAddress' format
11result = excel.evaluate('Sheet1!A3')
12
13print(f"The value of Sheet1!A3 is: {result}")
14
15# You can also update a cell value and see how it affects others
16excel.set_value('Sheet1!A1', 10)
17new_result = excel.evaluate('Sheet1!A3')
18
19print(f"After updating A1 to 10, the value of Sheet1!A3 is: {new_result}")