Error getting the reference a cell in another Excel workbook
I am working with an excel workbook that contains references to other workbooks, e.g., example1.xlsx has cells like:
='C:path\to\file\[example2.xlsx]Sheet1'!$B$1
But when I read it with openpyxl the value of the reference is 1, like this: ='[1]Sheet1'!$B$1
I'm reading the values just like this:
import pandas as pd
from openpyxl import load_workbook
load_workbook(file, data_only=False, keep_links=True)
df = pd.DataFrame(self.wb[sheet_name].values)
But it still does not work, and I do not get the expected reference.