Comment on page
Access Excel 365 sheet
Tags: #excel365 #snippet
!pip install sharepy
- username - username of sharepoint account
- password - password of sharepoint account
- domain - domain of sharepont account (eg mysite.sharepoint.com)
- path - its a full path of file in sharepoint . it can get from sharepoint dashbord by right click on file and select detail. then path can copy from right panel in dashboard
- sheet - name of sheet
- export - it is an optional parameter. it can be csv or xlsx. file will be exported to data_output folder based on this variable. set export as empty string or False if no need to export the file
domain = "cashstory.sharepoint.com"
path = "https://cashstory.sharepoint.com/sites/cashstory-external/Documents%20partages/CashStory%20Forecasting%20Module/Forecast.xlsx"
sheet = "Forecast"
export = "xls"
df = sharepoint_connector.connect(username, password, domain, path, sheet, export)