search

O365 / python-o365

A simple python library to interact with Microsoft Graph and Office 365 API
Apache License 2.0
1.67k stars 423 forks source link

How to add bulk json data to excel file #827

Open ZisanAalam opened 2 years ago

ZisanAalam commented 2 years ago

I want to add all the json to my worksheet residing in my one drive. For example: file : abcd.xlsx Headers: Name, Age, Address data : [{"Name":"Ram Bahadur","Age":"30","Address":"Kathmandu"},{"Name":"Shyam Bahadur","Age":"27","Address":"Pokhara"},{"Name":"Hari Bahadur","Age":"45","Address":"Chitwan"}]

alejcas commented 2 years ago

This is not possible for the moment. You will have to code it if you needed