Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,999 questions
Excel API can't reach data on the last column XFD
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 3%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mauricio
0
Reputation points
I'm using Excel API to read the header of a vertically small file, but which reaches the Excel column limit going to XFD. Calling both /worksheets('Sheet1')/usedRange(valuesOnly=true) and /worksheets('Sheet1')/range(address='A1:XFD1') endpoints will return empty values. Then, as soon as I delete the column XFD those requests bring the data.
I guess this is probably a bug on the Excel API.
Sign in to answer