CubeDrive   ->   API

Excel to online sheet "upload2ExistingFile"


With this API, 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

Log in to the system, choose an existing online sheet file, right-click to open the context menu, and choose "TAG".