Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Wed Mar 29, 2017 12:12 pm

Hello,

I have e performance problem on the LoadFromFile.

I try to load a xlsx file of 50Mo

Excel 2016 take 13 seconds to open file and LoadFromFile take 42 seconds...

I would like to know if it was possible to optimize this part to arrive at times equivalent to Excel see bettet.

Thanks,

file here : https://reportone75011-my.sharepoint.com/personal/vblattes_report-one_com/_layouts/15/guestaccess.aspx?docid=1eda62a41b78247b98b6efd76c0de40d1&authkey=ASjMDiODyw9gE_H31j2CNhs

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Thu Mar 30, 2017 2:07 am

Dear VincentB,

Thanks for your inquiry.
I have noticed the time issue and transferred it to our Dev team. Once there is any progress, we will inform you.
So sorry for the inconvenience.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Apr 18, 2017 7:15 am

Hello,

Have you made any progress on optimizations ?

Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Tue Apr 18, 2017 7:30 am

Dear VincentB,

Thanks for your information.
I will ask our Dev team and then update to you tomorrow.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Apr 18, 2017 8:02 am

Ok i will test it.

Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Wed Apr 19, 2017 3:52 am

Dear VincentB,

Thanks for your response.
Sorry that there is no progress about the optimization due to its complexity. But I have urged our Dev team, once there is any great progress, we will let you know. So sorry for inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed Apr 19, 2017 8:47 am

Hello,

Ok I'm looking forward to your return

Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Mon Apr 24, 2017 12:00 pm

Hello,

Sorry to insist but performance issues become a critical point.
Do not hesitate to notify me if you are doing optimizations.

Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Tue Apr 25, 2017 3:30 am

Dear VincentB,

Thanks for your inquiry.
So sorry that there is still no update about this issue, but I have urged our Dev team. Once there is any news, I will let you know immediately. We apologize for the inconvenience.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Fri May 19, 2017 12:54 pm

Hello

I have test Spire XLS hotfix 7.12.11 but I have not seen significant improvements about this issues.
Have you make progress on optimizations?

At your disposal
Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Mon May 22, 2017 3:36 am

Hello,

Thanks for your inquiry. Sorry, I am afraid that there is still no significant improvements about the issue due to its complexity. Once there is new update, we will let you know immediately.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Tue May 30, 2017 2:18 pm

Hello,

Sorry to insist but performance issues become a critical point.
Do not hesitate to notify me if you do optimizations.

Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Wed May 31, 2017 2:51 am

Dear VincentB,

Thanks for your inquiry.
Sorry that there is still no progress about the issue due to its complexity, and I am afraid it could not be implemented in short time. And we are doing our best to do optimizations, and will let you know as soon as there is any news. We apologize for the inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Jun 06, 2017 2:04 pm

Hello,

I understand that is complex problem for you but it's a critical point for me.

To find the slow point in the code I use DotTrace make by JetBrians (Resharper), it's very powerfull !
https://www.jetbrains.com/profiler/

If this can help you optimize !

Thanks

VincentB
 
Posts: 120
Joined: Thu Sep 15, 2016 9:44 am

Wed Jun 07, 2017 1:54 am

Dear VincentB,

Thanks for your understanding.
And I have posted your suggestion to our Dev team, and we will try our best to do the optimization. We will notify you when there is any great progress.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS