Opening xlsx doc from Onedrive

Hi, I have seen an article on your site about using xlsio to interact with files stored on onedrive, but it was specifically for uwp apps. Is this concept also possible from a winform app? Do you have a sample of this?

Thank you very much. This works great! I do have one question though that I hope might can help with. 

Thank you very much. I have actually figured it out. I added an if clause in the GetTokenAsync method checking to see if an account is logged into (using GetAccountsAsyc), and if so, it calls AcquireTokenSilentAsyc which works great.

Query	Response
Thank you very much. I have actually figured it out. I added an if clause in the GetTokenAsync method checking to see if an account is logged into (using GetAccountsAsyc), and if so, it calls AcquireTokenSilentAsyc which works great.	We are glad that you if could achieve your requirement.
I do have a fairly related question though in regards to using the graph API. XlSIO having compatibility with the API is awesome! Is there also compatibility between the treeViewAdv and Graph?     I currently load a network drive (such as C: drive) into that control using FileInfo. Is it possible to load the control with a OneDrive directory?	Could you please let us know whether the requirement is to load the contents of Excel file downloaded from the One Drive as nodes in the TreeViewAdv and then after performing some modifications in the nodes in TreeViewAdv, you want to load the modified TreeViewAdv as Excel file and upload back to One Drive.  Also please let us know incase if we have misunderstood the query in TreeViewAdv as it will help us to further proceed on this.

Keerthi.

Hi, I'm not dealing with excel documents in the tree view.

Hi Travis,

Thanks for your update.

We have checked your reported query and we understand that your requirement is to perform LoadOnDemand in TreeViewAdv. We have a LoadOnDemand sample in which we have loaded the directories and folders from the machine as nodes in TreeViewAdv. Please find the sample in the following location and let us know whether it helps to achieve your requirement where you need to perform LoadOnDemand from the OneDrive.

Sample: https://www.syncfusion.com/downloads/support/forum/150848/ze/TreeViewAdv_LoadOnDemand-2061933052  

Regards,
Gokul S

Thanks for your response. This is not quite what I'm looking for though. I am already loading my local network drives into the treeview. What I was hoping to do is load the onedrive drives using the graph api, if that is possible.

Hi Travis,

Thanks for your update.

We will check with the Microsoft Graph API to load the OneDrive contents into the TreeViewAdv and will let you know on or before February 4, 2020. We appreciate your patience until then.

Regards,
Gokul S

Hi Travis,

Sorry for the inconvenience caused.

As we faced some delay in getting the permission from accessing the OneDrive for registering the application in the portal, we are unable to update the compatibility of loading the contents into TreeViewAdv today as promised before. We are currently working on this with high priority and will provide the complete details on February 5, 2020. We appreciate your patience until then.

Regards,
Gokul S

Hi Travis,

Sorry for the inconvenience caused.

We are still facing the issues in accessing the OneDrive content through MicrosoftGraph as it needs organization admin approval for accessing it. We have directed to the corresponding team for their approval and once we get the approval for the same, we will check the reported query in TreeViewAdv and provide you further details on February 7, 2020.

Meanwhile we are also checking ways to retrieve the details of files and folders and its content in order to load them in TreeViewAdv. Also if possible, let us know incase if you come across any of the ways to retrieve the details.

Regards,
Gokul S

Thank you for working so diligently. Your help is greatly appreciated!

Hi Travis,

Thanks for your update.

We are still waiting for the organization level administrator approval from the corresponding team. We will provide you further details on February 7, 2020. We appreciate your patience until them.

Regards,
Gokul S

var stream1 = await graphClient.Me.Drive.Root.Children.Request().GetAsync();

var stream2 = await graphClient.Me.Drive.Root.ItemWithPath("Notebooks").Children.Request().GetAsync();

Thank you for your help on this! After some experimentation I sort of have it working. I am able to load the treeview with the folders with only a few occasional instances of odd behavior, which I can deal with. 

Thank you for your feedback, but this is not what I am looking for. I am already able to load folders and docs from local drives easily. I want to now treat OneDrive the same way, loading folders into a multi-column tree view and documents into a gridcontrol (when a folder is selected).