I am trying to load a large excel file from an API, initially the file opens up blank until the API returns the complete set of data, is there a way I can show up the loading status or can partial load be shown?
SPSangeetha Priya Murugan Syncfusion Team October 19, 2022 07:58 AM
For open and saving the excel file we
have used ASP.NET workbook server-side
action (Open, Save). While opening the excel file we have sent the request
from client to server and convert that excel into the spreadsheet supported
JSON format using our XLSIO library. Once the server process is completed, we
have sent that converted JSON into client side. In client side we have update
the model in the backend after only we will refresh the UI. And it is dependent
upon the size of the file loaded, if the file size is small, it will refresh
the UI in faster manner. If the file size is larger the server and client-side
process take some time. And we can’t be able to refresh the UI for visible range
(partial data) because UI will refresh after the server and model updation is
done in the backend. So only we have displayed the waiting popup while
loading the file in the spreadsheet.
Kindly get back to us if you need further assistance