I downloaded and customized this project. this is working fine without any issue with onedrive excel files/items. but i have to do this using office 365 sharepoint online only. which is not working.
i am able to get file id using service point as follows:
var serviceEndpoint = "https://graph.microsoft.com/beta/sites/mydomain.sharepoint.com:/foa/bd:/lists/Budget/items";

but i am not sure how should i define workbook end point url with sharepoint to update/manipulate same excel file data. current workbook end point url as follows(which is not working):
var workbookEndpoint = "https://graph.microsoft.com/beta/sites/mydomain.sharepoint.com:/foa/bd:/lists/Budget/items/" + fileId + "/workbook";

my complete method to update cell value in excel file on sharepoint as follows:

public static async Task UpdateExcelCellValue_Sharepoint(string accessToken, string cellAddress, string val) { string worksheetName = "Parameters"; var serviceEndpoint = "https://graph.microsoft.com/beta/sites/mydomain.sharepoint.com:/foa/bd:/lists/Budget/items"; HttpClient client = new HttpClient(); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", accessToken); var filesResponse = await client.GetAsync(serviceEndpoint + "?$select=name,id"); if (filesResponse.IsSuccessStatusCode) { var filesContent = await filesResponse.Content.ReadAsStringAsync(); JObject parsedResult = JObject.Parse(filesContent); foreach (JObject file in parsedResult["value"]) { var name = (string)file["id"]; if (name.Contains("173")) { fileId = (string)file["id"]; break; } } } else { //Handle failed response } //Set up workbook and worksheet endpoints var workbookEndpoint = "https://graph.microsoft.com/beta/sites/mydomain.sharepoint.com:/foa/bd:/lists/Budget/items/" + fileId + "/workbook"; var worksheetsEndpoint = workbookEndpoint + "/worksheets"; var patchMethod = new HttpMethod("PATCH"); var summaryTableRowJson = "{" + "'values': '" + val + ".csv'" + "}"; var colNamePatchBody = new StringContent(summaryTableRowJson); colNamePatchBody.Headers.Clear(); colNamePatchBody.Headers.Add("Content-Type", "application/json"); var colNameRequestMessage = new HttpRequestMessage(patchMethod, worksheetsEndpoint + "('" + worksheetName + "')/range(address='Parameters!B2')") { Content = colNamePatchBody }; var colNameResponseMessage = await client.SendAsync(colNameRequestMessage); }
any help would be highly appreciated.

Hello everyone. I ran the example application and followed the steps described in the documentation, and the application ran well, I could see the graph explorer and performed some queries well enough.

Now, I have an ASP.NET Core application with Work & School account login, as generated by the Visual Studio 2015 Update 3 wizard. I'm trying to integrate your example, but alas I can't. For instance, copying SessionTokenCache won't work, because of the usage of System.Web.dll, which for some reason I cannot reference in my project.

I created my own version, but I'm not sure whether this will work as intended (see code at the end).

Do you have some guidelines as to how to run the example for ASP.NET Core? Or do you have some example in ASP.NET Core (I haven't been able to find one).

Thanks in advance.

public class SessionTokenCache
    : TokenCache
{
    private HttpContext context;
    private static readonly object FileLock = new object();
    private readonly string CacheId = string.Empty;
    public string UserObjectId = string.Empty;

    public SessionTokenCache(string userId, HttpContext context)
    {
        this.context = context;
        this.UserObjectId = userId;
        this.CacheId = UserObjectId + "_TokenCache";

        AfterAccess = AfterAccessNotification;
        BeforeAccess = BeforeAccessNotification;
        Load();
    }

    public void Load()
    {
        lock (FileLock) {
            Deserialize((byte[])context.Session.Get(CacheId));
        }
    }

    public void Persist()
    {
        lock (FileLock) {

            // Reflect changes in the persistent store.
            var bytes = Serialize();
            var x = System.Text.Encoding.UTF8.GetString(bytes);
            context.Session.Set(CacheId, Serialize());

            // After the write operation takes place, restore the HasStateChanged bit to false.
            HasStateChanged = false;
        }
    }

    public override void Clear(string clientId)
    {
        base.Clear(clientId);
        context.Session.Remove(CacheId);
    }

    // Triggered right before MSAL needs to access the cache.
    // Reload the cache from the persistent store in case it changed since the last access.
    private void BeforeAccessNotification(TokenCacheNotificationArgs args)
    {
        Load();
    }

    // Triggered right after MSAL accessed the cache.
    private void AfterAccessNotification(TokenCacheNotificationArgs args)
    {
        // if the access operation resulted in a cache update
        if (HasStateChanged) {
            Persist();
        }
    }
}

It is stated that only only excel functions work in MS graph. However,
the Graph/Rest Api has extends its ability in that you can select/copy objects (https://docs.microsoft.com/en-us/graph/excel-write-to-workbook)

Where can I find all the available "abilites" or "functionality" of Graph/Rest API? I have spent ~an hr searching for a list, but am only able to find scatered functionality like selecting a cell or range (https://stackoverflow.com/questions/45782087/sharepoint-2013-rest-api-call-to-extract-excel-specific-cells?rq=1 )

Hi,
I'm preparing the demo for the SPSNYC tomorrow and the app is not adding/listing entries for tasks.
The issue is caused by the fact that tables('toDoList') gives 404 in the excel helper.
I Had to replace it by tables('1') to get it to work.
I wonder if it's a temporary issue with the beta graph API or if I should submit a PR?
Also it might be related to the fact that the user I'm testing against in office 365 is set up in french.