I have an xlsx file that I am trying to parse and one of the cells references an xla add-in function.
='C:\Program Files (x86)\abc\Query and Analysis\LsAgXLB.xla'!AG_SMRT("0,Summary Report 1,1")
That file does not exist on my local machine but likely existed on the person's who created the file.
However, looking at the cell in Excel, it does display a text value 'CTP116701'. But the actual value of the cell is the xla function. Where and how is it pulling the 'CTP116701' value?
I'm trying to use Python and openpyxl to parse the spreadsheet.
I was able to pull the previously computed and stored value of the cell by opening the workbook in data_only mode:
wb = openpyxl.load_workbook(filename, data_only=True)
While investigating, I did change the file extension to .zip and found the worksheet xml file. This was helpful because I could see that the 'CTP116701' value was indeed stored in the cell along with the function string.