Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I called an api rest (get method) which sends me back a json response containing the information of the excel file that I will read the data.
The form of this json file is the following
{
"entry":{
"isFile":true,
"createdByUser":{
"id":"trestTATA",
"displayName":"Helen Marc"
},
"modifiedAt":"2020-04-11T08:21:43.904+0000",
"nodeType":"cm:content",
"content":{
"mimeType":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"mimeTypeName":"Microsoft Excel 2007",
"sizeInBytes":3396,
"encoding":"UTF-8"
},
"parentId":"bcb4390c-006c-44cd-b526-0d240859bca2",
"aspectNames":[
"rn:renditioned",
"cm:versionable",
"cm:auditable",
"cm:thumbnailModification",
"ged:attributs"
],
"createdAt":"
2020-04-11T08:21:43.904+0000
","isFolder":false,
"modifiedByUser":{
"id":"trestTATA",
"displayName":"Helen Marc"
},
"name":"EMPLOYEE.xlsx",
"id":"7lk4578-4175-4e9f-8465-26bc784512c",
"properties":{
"ged:entite":"MERTA",
"cm:versionType":"MAJOR",
"ged:filiere":"N/A",
"cm:versionLabel":"1.0",
"cm:lastThumbnailModification":[
"doclib:1626079366562"
]
}
}
}
This excel file contains a column named salary and containing several salary lines.
How can I read the content of my excel file with tFileInputRaw
Why don't you use tFileInputExcel to read the Excel file?
My excel fil is located in server and the file contains a id . I must call a api rest to get the file excel.