How to read an excel file with linked data type

[FrancisPeds]

Hi,

I am trying to read an excel file with a geography data type. When I try to get the values, it shows up as null. Any help would be greatly appreciated.

[andersnm]

Hi, can you make two files, one XLS and one XLSX using this data type and attach to the ticket? Otherwise somebody have to spend hours in Excel just trying to figure out what you're asking for

[FrancisPeds]

Hi, apologies for the incomplete data. I have attached a sample file
Sample.xlsx

I have looked and it seems like only xlsx files support these linked data type. The geography data type shows a card with information regarding the place in the cell:

In my sample code, the values of those cells are empty

There are other linked data types, more info can be seen here