Excel WorkbookRange always empty using Microsoft Graph SDK v5

Asked Mar 29 '23 at 12:12

Active Mar 29 '23 at 16:14

Viewed 123 times

I'm struggling with reading data out of an Excel Worksheet after upgrading to Microsoft Graph .NET SDK to v5.

This code is working with v4 of the SDK:

WorkbookRange range = await client.Me
    .Drive.Items[bookId]
    .Workbook.Worksheets[tabId]
    .Range("A1:XX1")
    .Request()
    .GetAsync(cancellation)
    .ConfigureAwait(false);

var data = range.Text.Deserialize<List<List<string>>>()!;

After moving to v5, I am able to get the range, but Text is always empty:

WorkbookRange? used = await client
    .Drives["Me"].Items[bookId]
    .Workbook.Worksheets[tabId]
    .UsedRangeWithValuesOnly(true)
    .GetAsync(cancellationToken: cancellation)
    .ConfigureAwait(false);

WorkbookRange? range = await client
    .Drives["Me"].Items[bookId]
    .Workbook.Worksheets[tabId]
    .RangeWithAddress("A1:XX1")
    .GetAsync(cancellationToken: cancellation)
    .ConfigureAwait(false);

How do I get data from these ranges?

edited Mar 29 '23 at 16:14

Marc LaFleur

31,987
4
37
63

asked Mar 29 '23 at 12:12

Stephan Hoffmann

Is `Values` also empty or only `Text`? – user2250152 Mar 29 '23 at 12:45
`Values` is also empty. – Stephan Hoffmann Mar 29 '23 at 12:46
Be empty do you mean it is null? – user2250152 Mar 29 '23 at 12:53
Its a `Json` object with no content. Its not null. – Stephan Hoffmann Mar 29 '23 at 13:02
I can confirm the same behavior. I've created a bug for it: https://github.com/microsoftgraph/msgraph-sdk-dotnet/issues/1783 – user2250152 Mar 29 '23 at 13:29
Still the case with nuget version 5.6.0 – Stephan Hoffmann Apr 17 '23 at 10:43
Still the case with nuget version 5.11.0 – Stephan Hoffmann May 25 '23 at 08:48

Excel WorkbookRange always empty using Microsoft Graph SDK v5

0 Answers0