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
