CubeDrive   ->   API

Excel to online sheet 【upload2ExistingFile】


With this APT, users can upload Excel and update the existing sheet data.

Name: {{baseuri}}/sheet/upload2ExistingFile

Parameter:

http method: POST

Steps


The following lists the steps

@baseuri = http://localhost:8080/cubedrive-webapp
@username= admin
@password= abcabc
@xAuthToken=bbb6c793-832c-4733-9601-a023366d918f

###
GET {{baseuri}}/getLogin?j_username={{username}}&j_password={{password}}

###
POST {{baseuri}}/sheet/upload2ExistingFile
X-Auth-Token: {{xAuthToken}}
Content-Type: multipart/form-data; charset=utf-8; boundary=----WebKitFormBoundary7MA4YWxkTrZu0gW

------WebKitFormBoundary7MA4YWxkTrZu0gW
Content-Disposition: form-data; name="tagId"

X9IxyAGE5PQ
------WebKitFormBoundary7MA4YWxkTrZu0gW
Content-Disposition: form-data; name="filePath"; filename="周报表.xlsx"
Content-Type: application/octet-stream

< /home/test.xlsx
------WebKitFormBoundary7MA4YWxkTrZu0gW--    
    

Extra information


Get the existing excel file tagId

Login system, you can choose the existing online sheet file, click right button to find context menu and choose "TAG"。