Posted 7 May 2022, 10:25 pm ESTHi, We are using SpreadJs 13.0.4 and we can export it to Excel and save it using Spread-ExcelIo and "file-saver'. However we need to export SpreadJs and then open an Excel document directly from it. ExcelJs support to open document using "Excel.createWorkbook(https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-workbooks#create-a-workbook)" which accepts base64 string. So I need help to convert SpreadJs exported blob/json to appropriate string for this operation.
Export SpreadJs into Excel Document without saving it on file system
Posted by: mirfan on 7 May 2022, 10:25 pm EST
Replied 9 May 2022, 3:20 pm ESTHi,
For this, you need to use the excel URI scheme and pass the URI to the template, based on the HTTP or HTTPS scheme. for this, you may need to implement a server that returns the file. Please refer to the following code snippet and attached official doc of URI which explains the same.
//here you ned to to implement the backend http server which return the excel file
office URI Scheme: https://docs.microsoft.com/en-us/office/client-developer/office-uri-schemes
Replied 9 May 2022, 7:53 pm ESTHi Avinash,
So do you mean, first we need to send exported SpreadJs instance JSON blob to Server and then save it to Server File System folder as Excel and then send that Excel file from Server and open it using this URI Schema?
Really this is the only solution?
Replied 10 May 2022, 7:00 pm ESTHi,
The only solution is to use the excel URI scheme since the web apps do not have access to the native application. We tried directly passing the blob/base64 to the URI scheme but excel only supports the URI to the document, based on the HTTP or HTTPS scheme. So that is why you need to return the excel file from the backed.
I hope it clarifies the issue.