Place XSTRING ( Excel ) into Sharepoint using REST

Question

Place XSTRING ( Excel ) into Sharepoint using REST

Srikanth 21

Hi All,

I am working on uploading the .xlsx file in Sharepoint using REST services. We have data in XSTRING format, i am getting an 'Bad Request' error if i try to send the request.
Is there a way we can send the excel file in XSTRING format. Appreciate your help.

Thank you

1 answer

Your answer

Answer 1

RaytheonXie_MSFT 40,471 Microsoft External Staff

Hi @Srikanth ,
Per my test, you can use following url to upload a file to sharepoint.
https://xxx.sharepoint.com/sites/aaa/_api/web/GetFolderByServerRelativeUrl('/sites/aaa/Document/')/Files/add(url='test.xlsx',overwrite=true)

You can also refer to following code to upload a file by rest api
https://www.c-sharpcorner.com/blogs/upload-documents-show-documents-in-a-page-using-sharepoint-rest-api

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Srikanth 21 Reputation points

2022-07-22T04:54:24.693+00:00

Hi @RaytheonXie_MSFT ,
Yes we can post the file in this way, but we have data in xstring format. Is there a way to upload the xstring format data.
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2022-07-25T20:07:34.733+00:00

Hi @Srikanth ,
Per my test, XSTRING format Excel file is not supported in Rest API to upload file to sharepoint. Excel's XML is a complicated file format, with several files that work together to form the worksheets. Refer to Microsoft's File format reference for Word, Excel, and PowerPoint for details. It's non-trivial to interpret this, so you will usually be a lot happier with abap2xlsx.
Srikanth 21 Reputation points

2022-07-27T05:28:47.257+00:00

Hi @RaytheonXie_MSFT , We needed to place an excel file in the Sharepoint which was generated by the abap2xlsx. I would get data in xstring or binary format. But i could not send the binary format from SAP. If i try with xstring format, am getting 'Bad request' issue. Thank you
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2022-08-01T07:50:39.807+00:00

Hi @Srikanth ,
Please try to convert xstring to binary. You can refer to the following link
https://answers.sap.com/questions/7280922/print-label-image-in-gif-format-returned-by-web-se.html?childToView=8851801

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
RaytheonXie_MSFT 40,471 Reputation points Microsoft External Staff

2022-08-05T09:58:08.583+00:00

Hi @Srikanth ,
Would you tell me whether your issue has been resolved or have any update?
I am looking forward to your reply.

Have a nice day!

Thanks,
Raytheon Xie

Share via

Place XSTRING ( Excel ) into Sharepoint using REST

1 answer

Your answer