Microsoft Graph Excel refers to the Excel APIs in Microsoft Graph. This tag should always be used in conjunction with the [microsoft-graph] tag.
Questions tagged [microsoft-graph-excel]
18 questions
2
votes
1 answer
Update Values in Excel Named Ranges using Microsoft Graph API
I have an Excel file loaded into Office 365 that is accessible via the Microsoft Graph API with many named ranges, some are individual values, some are blocks of cells.
I can successfully update individual values using the API, but when I try to…
gotmike
- 1,515
- 4
- 20
- 44
2
votes
1 answer
How to build a Ms graph api query filter on array object?
I am planning to leverage List Groups Ms graph API to list O365 groups in my organization and, later filter them for Yammer groups.
When I use this API in graph explorer it returns following response object.
{
"@odata.context":…
Royjad
- 99
- 3
- 13
2
votes
0 answers
Microsoft Graph API and Excel Charts
Why Microsoft Graph API
https://graph.microsoft.com/v1.0/me/drive/root/children('GraphTest.xlsx')/workbook/worksheets('Foglio1')/charts
throws an error
{
"error": {
"code": "GeneralException",
"message": "There was an internal…
dash1e
- 7,677
- 1
- 30
- 35
1
vote
1 answer
In the .net Graph SDK, Range().Clear() gives compilation error and doesn't work as told in documentation
I am using .net Graph SDK (Microsoft.Graph) version 3.21. I am following the below documentation link from Microsoft:
https://learn.microsoft.com/en-us/graph/api/range-clear?view=graph-rest-1.0&tabs=csharp
In this link, it is said that we can clear…
Srivardhan Hebbar
- 13
- 1
- 7
1
vote
1 answer
How can I append or add rows below the last row. (in worksheet)
It is possible to append a row in a table using the method below:
POST /workbook/worksheets/{id|name}/tables/{id|name}/rows/add
How can I do the same but in a worksheet?
Now it's only possible to Update with a specific range:
PATCH…
Bruno Yuzo
- 469
- 5
- 18
1
vote
1 answer
Unable to get worksheet list of shared workbook in Microsoft Graph API
I have found the endpoint from this SO question. But what is the scope need for the same.
I tried these scopes "user.read", "files.read.all", "files.read", "files.read.selected","files.readwrite","files.readwrite.all","sites.read.all",…
Praveenkumar
- 921
- 1
- 9
- 28
1
vote
0 answers
Preview links generated for .csv and .xls files erroring out
When testing the preview endpoint for .xls and .csv files a getUrl is returned as if the operation has been successful,
But when using the returned link the preview page just seems to error out, as per below:
Is there a way to generate embedable…
KMR
- 792
- 13
- 21
1
vote
1 answer
How to fix: bug starting 8/20/2019: UsedRange returns null Values
Starting around 1AM PST on 8/20/2019, the UsedRange.Values property has started returning null.
Not on all Excel spreadsheets but on some, and we can't yet determine what factors cause it. Seems like a bug in the graph APIs, as this was working…
Praveen Seshadri
- 67
- 5
1
vote
1 answer
‘IWorkbookWorksheetRangeRequestBuild’ does not contain a definition for ‘Format'
I am using the Microsoft Graph SDK to update range format of the worksheet as code snippets shown below:
GraphServiceClient graphClient = new GraphServiceClient(authProvider);
var workbookRangeFormat = new WorkbookRangeFormat
{
…
xcg
- 11
- 1
1
vote
1 answer
Getting "Property 'openWith' on type 'oneDrive.item' is not a navigation property." when trying to access workbook api
My code was working just the day before. As I was trying to work on the progress yesterday.
The application was try to createSession, and it was this error.
"code": "generalException",
"message": "Property 'openWith' on type 'oneDrive.item' is not…
BlueOrbitz
- 76
- 3
1
vote
1 answer
Microsoft Graph API $filter=name eq 'foo' query not working on GET workbook/tables/{id}/columns. No error and no filtering
I'm looking at a table (Table1) inside an Excel book saved on my OneDrive for Business account. I then want to get the maximum value in the CREATEDDATE column from this table.
I want to avoid pulling down the whole table with the API, so I'm trying…
chase hill
- 13
- 2
0
votes
1 answer
How to read data from Microsoft Graph using a get request?
My goal is to read the data inside an Excel at azure with some get request.
I am trying to get the JSON contain the information form one of my Excel files.
I am using the "Excel: used range in worksheet", it can be found in the page…
Hygison Brandao
- 590
- 1
- 4
- 16
0
votes
1 answer
How can we create table without headers in Microsoft Excel Graph API?
I need to create a table in Microsoft Excel using Graph API.
https://learn.microsoft.com/en-us/graph/api/worksheet-post-tables?view=graph-rest-1.0
As per above document, if we set hasHeaders field as false in the create table API, it should create a…
Shanan
- 112
- 1
- 8
0
votes
3 answers
Error when adding rows to a sharepoint excel workbook table MaxRequestDurationExceeded
here is the full error
{
"error": {
"code": "MaxRequestDurationExceeded",
"message": "We're sorry. We couldn't finish what you asked us to do because it was taking too long.",
"innerError": {
"code":…
chip
- 3,039
- 5
- 35
- 59
0
votes
1 answer
How to duplicate a worksheet with its content with microsoft graph excel api
i'm trying to duplicate a worksheet with its content into another new one.
In origin what i have is a table and i want to copy the worksheet with the table and its content.
In programming in PHP and i'm trying this:
$sheet =…
alvaro
- 43
- 1
- 8