We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Large Excel data is not loaded

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?


1 Reply

SP Sangeetha Priya Murugan Syncfusion Team October 19, 2022 07:58 AM


Hi Gokulan,


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 regarding.


Regards,

Sangeetha M                   


Loader.
Live Chat Icon For mobile
Up arrow icon