Unable to open an external XLSX file with same code as demo but in nextjs

[Majid Razmjoo]

Neither it works with openUrl nor using the ref and then setting the file in created event. Here is the codesandbox.

https://codesandbox.io/s/next-js-forked-dgibx3?file=/index.html

[Vasanth Ravi]

Hi Majid,

Upon verifying your provided code-sandbox sample, we noticed that you had provided the file load URL on the openURL.

 

openUrl="https://js.syncfusion.com/demos/ejservices/data/Spreadsheet/LargeData.xlsx"

On the open URL, you must provide the server-side action URL, not the file load URL. With the server-side action URL, we make a call to the XLSIO engine and perform the import action.

 

You must provide the file load URL only on the fetch method, not on the open method. We have modified the sample and attached it below for your reference. 

 

Sample Link: ​https://codesandbox.io/s/next-js-forked-mxijnl?file=/index.js 

Also attached are the API links for reference.

https://ej2.syncfusion.com/react/documentation/spreadsheet/open-save#open-an-external-url-excel-file-while-initial-load

https://ej2.syncfusion.com/react/documentation/api/spreadsheet/#open

https://ej2.syncfusion.com/react/documentation/api/spreadsheet/#openurl