Hi
Mahesh,
Regarding loading performance related query:
There
are limitations over importing the excel file into the spreadsheet component.
Find the below benchmark of our Spreadsheet with importing the excel file.
|
Scenario
|
Rows
* Columns
|
|
Import
with normal data (without any formatting)
|
50,000
* 20 (1 million cells)
|
|
Import
data with format (Row height/ cell formats & Merging Wrap text randomly)
|
30,000
* 10
|
Based
on our limitations, if the formats and formulas are applied in the imported
Excel, the threshold limit may vary. So, loading such a large file into the
spreadsheet takes some time, because the construction of JSON and the loading of
such large JSON into the spreadsheet are tedious processes.
If
you need to skip the loading of a larger file without hanging the spreadsheet,
you have two options to restrict the file by importing into the spreadsheet and
causing the server to get hanged. Those properties are.
MaximumDataLimit.
( Value set to the maximum data (cell) count allowed )
MaximumFileSize
( File size to be set in Byte )
Enable
this in the Open action on the server side, as shown below.
CODE
BLOCK:
|
public
IActionResult Open([FromForm]IFormCollection openRequest)
{
OpenRequest open = new OpenRequest();
open.File = openRequest.Files[0];
// For reference value has been set to 5MB limit.
open.ThresholdLimit.MaximumFileSize = 5000000;
var openbook = Content(Workbook.Open(open));
return openbook;
}
|
It
will throw the below alert dialog to skip the opening of larger size in
spreadsheet. By clicking the Cancel button, it will skip the importing
progress. If you click OK button, then spreadsheet again tries to load the
file.
Regarding
Filtering related issue:
We
have checked your reported filtering issue by importing the 30K rows and 10
columns contained excel file. And the filtering works properly in our end without
throwing any error. For your convenience, we have prepared the video demonstration
of this issue in our demo site. Please find the below attachment. Meanwhile,
before we proceed further with this query, please get back to us with the below
details. Based on that we will be able to check and provide you a better
solution quickly.
1.Please
share your issue replicable excel file by replacing with dummy data.
2.Please
share spreadsheet rendering and customization related codes
3.Kindly
share your Essential studio product version for both scripts and assemblies.
