Issue with Loading speed with Excel file and Stuck

[Vikash Kumar]

Hi there , I'm facing Loading Speed issue with Spreadsheet Excel file  . I have one Excel sheet which I want to Load initialy on page load . After loading heavy file of Excel sheet it's becomes very slow . For Example the Excel file I have it's size around 200kb after loading this file , it's took lot of time to jump any other Sheet on this . Everytime browser send notification for Wait or Exit page. I'm using Syncfusion Spreadsheet Php version . I'm attaching the Excel sheet with this . Please get the attach file . 

Please fix this issue as soon as possible . I have very urgent requirement.  Looking forward to your quick response .  Even possible please also provide me some sample file of php to load the Attached Excel file initially with all tools and Component with Dropdown funtion . One more thing I want to say please also check the speed after loading the sample excel file which I'm sending with this conversation . It should be open quickly after clicking any other sheet. 

The Excel file I'm sending to you having 12 Sheets combined with this Like Summary , Bank1 , Bank2 , bank3 and so on .. When you try to jump any other sheet by click it's took lot of time to open that sheet . 

Looking forward to your response . 

Sample Code

------------------

    <?php

    require FCPATH.'syncfusion/SampleBrowser/EJ/AutoLoad.php';

$importSetting = new EJ\Spreadsheet\ImportSetting();

$importSetting->importMapper("//js.syncfusion.com/demos/ejservices/api/Spreadsheet/Import");

$importSetting->importUrl("".base_url()."global_assets/vendor/filemanager/files/Bank_statement/BANK_statement_underwritting.xlsx");

$exportSetting = new EJ\Spreadsheet\ExportSetting();

$exportSetting->excelUrl("//js.syncfusion.com/demos/ejservices/api/Spreadsheet/ExcelExport")->csvUrl("//js.syncfusion.com/demos/ejservices/api/Spreadsheet/CsvExport")->pdfUrl("//js.syncfusion.com/demos/ejservices/api/Spreadsheet/PdfExport");

    $spreadsheet =  new EJ\Spreadsheet("Spreadsheet");

    $scroll = new EJ\Spreadsheet\ScrollSetting();

    $scroll->height(900);

    echo $spreadsheet ->allowFormulaBar(false)->importSettings($importSetting)->exportSettings($exportSetting)->scrollSettings($scroll)->loadComplete("loadComplete")->render();

    ?>

Thanks & Regards 

Attachment: BANK_statement_b3e8d2df.zip

[Sangeetha Priya Murugan]

Hi Vikash Kumar, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported performance issue in our EJ1 Spreadsheet with our latest version (18.3.52). And the excel file loaded within (4 ~ 5 seconds) in spreadsheet. We would like to let you know that we have rendered only the activeSheet only and the remaining sheets are created while switching the sheets. So, only the time delay occurs while switching the sheet, once sheet created the time delay won’t occurs next time. 

 

 Meanwhile, in your excel file there are nearly 8000 formula cells available in workbook and cell formats (color, border  ...) are applied  randomly, so rendering of such formatted sheets in spreadsheet takes some amount of time.  

 

And the sheet is in protected state so only the toolbar, dropdown buttons are in disabled state and it is our behavior as like as MS Excel. To enable the toolbar buttons you need to unprotect the sheet. For your convenience, we have prepared the video demonstration of this. Please find the link below. 

 

Video Link: https://www.syncfusion.com/downloads/support/forum/160418/ze/EJ1-spreadsheet-2107527087 

 

And we would like to let you know that the time delay for the imported excel contains applied formats varies accordingly, Please find the below benchmark of our EJ1 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

 

Suggestions to improve the performance at initial load. 

 

1. If you have importing more than one sheet, we would suggest you to use “allowSheetOnDemand” as true in importSettings It will import only the active sheet so it will improve the performance. While switching remaining sheets are created one by one at the time only it will takes time to rendering the sheets and apply the formats in it. Otherwise it won’t take time for already created sheets. 

 

2. If you are using our online ejServices for Import/Export functionality use Service locally, in your application it will improve performance. 

 

Could you please check the above details and get back to us, if you need any further assistance 

 

Regards, 

Sangeetha M 

 

[Vikash Kumar]

Suggestions to improve the performance at initial load. 

 

1. If you have importing more than one sheet, we would suggest you to use “allowSheetOnDemand” as true in importSettings It will import only the active sheet so it will improve the performance. While switching remaining sheets are created one by one at the time only it will takes time to rendering the sheets and apply the formats in it. Otherwise it won’t take time for already created sheets. 

Reply :  Can you please give me Example how to use  “allowSheetOnDemand” as true in importSettings  . 

 

2. If you are using our online ejServices for Import/Export functionality use Service locally, in your application it will improve performance. 

 Reply : I am using Linux server and using Php so how to use Web services Locally ?? I have the Licensed version in which all Web services folder available for ASP.Net only .. can you please provide me Web Services file for Php too. So this way I can use the Web service part on my server . 

[Vikash Kumar]

Hi dropdown still not working in Excel file even I remove the Unprotected restriction from the file ... Please check once again and if possible please provide me sample file with initial load this Excel file which i sent to you .. So I can test  from here too . 

For better understanding Please open the Excel file with Microsoft Office tool .. So, you can see the all Dropdown there perfectly . 

[Vikash Kumar]

Hi Please find the attach file . I need to enable all the tools in the reference image file even want to enable dropdown too with this Spreedsheet . I am Using Ej2 Javascript Spreadsheet similar like Image file which I'm attaching with this . But Dropdown not working with this . SO I am looking for the way to enable Dropdown + all Spreedsheet tool. 

for better understanding please check this demo  link .. 

https://ej2.syncfusion.com/demos/?&_ga=2.196745583.21392911.1606870262-192086099.1603265130#/material/spreadsheet/default.html

I am using same Spreadsheet . You can see in this spreedsheet Not more tools available . Even when you open the Excel file  with this spreadsheet which I sent to you in my previous message .you will notice dropdown function will not work .

Attachment: image_6772de00.zip

[Sangeetha Priya Murugan]

Hi Vikash Kumar, 

 

Thank you for your update. 

 

We have checked your reported issue and we confirmed this as defect and the fix will be available in our first week of January month (January 6^th) patch release, we appreciate your patience until then. You can track the status of this improvement using below link from our feedback portal,  

 

Feedback Portal Link: https://www.syncfusion.com/feedback/20471/need-to-fix-the-issue-while-importing-the-excel-with-the-list-validation 

  

Could you please check the above details and get back to us, if you need any further assistance 

 

Regards, 

Sangeetha M 

[will]

 When a workbook has too many cell styles, shapes, or formatting, it can cause Excel Online to take many times longer to open a file than usual. To see the cell styles for an Excel workbook, locate the Home tab, and then click the Down arrow in the lower-right corner of the Styles group

Regards,

Will

[Sangeetha Priya Murugan]

Hi Will,

Before we proceed further, please share the below details,

1.Whether you are using EJ1 or EJ2 spreadsheet?

2.If you are using our online service for import/export action, you can use the local web service for open/save action.

3. Share your dummy issue replicable excel file?

4. Share your spreadsheet rendering and customization codes.

We have some limitations in web platform for number of elements rendered in the DOM. Our spreadsheet maximum rendered 1 million cells that dependes upon the rows and columns. The time delay in spreadsheet varies depending upon the cell count and formats applied in the spreadsheet, please find the below benchmark of our Spreadsheet.

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

Could you please check the above details and get back to us with the above requested information, based on that we will check and provide you a better solution quickly.

Regards,

Sangeetha M

[Sim]

Unfortunately, I'm not able to provide a specific solution to your issue without more information. Could you please provide more details about the issue you are experiencing, such as the version of Excel you are using, the size of the file, and any other relevant information? Additionally, if you could provide a sample file that reproduces the issue, that would be very helpful.