18 lines
772 B
Python
18 lines
772 B
Python
|
|
from datetime import datetime
|
|
from synology_drive_api.drive import SynologyDrive
|
|
import pandas as pd
|
|
|
|
# default http port is 5000, https is 5001.
|
|
with SynologyDrive('ckh08045', 'Darknes1!', 'cckb9998.synology.me', '10002', https=False, dsm_version='7') as synd:
|
|
# response = synd.create_folder('test1111', 'team-folders/Listup')
|
|
# response = synd.list_folder('team-folders/Listup/')
|
|
# synd.download_file('/team-folders/Listup/01.osheet') # write your code here
|
|
# print(f"{response}")
|
|
|
|
# download osheet as xlsx and read into pandas dataframe.
|
|
bio = synd.download_synology_office_file('/team-folders/Listup/01.osheet')
|
|
# bio = synd.download_file('/mydrive/test.osheet')
|
|
data = pd.read_excel(bio, sheet_name=None)
|
|
|
|
print(f"{data}") |