Performance on range names

Aspose.Cells Product Family
1

Hello,

I have a performance issue with large excel files (150k rows plus). I know excel in general is not the propriate formate to handle large amounts of data, but in this case it is unavoidable. Here is my problem:

I’m creating a range for a single cell and defining a name on it.

Range currMappingRange = ws.Cells.CreateRange(i, 1, 1, 1);
currMappingRange.Name = result[i].RangeName;

The API is able to handle the data within the cells quite performant. Accessing times etc are brilliant. Well done! When it comes to range names it is not so performant. The 2nd line increase exponentially in processing time after executing it several thousand times, which is not acceptable for me.

Do you have any advice for me?

Another issue I have is, that the name is visible to the user. In my scenario it should not be visible to the user only to scripts. Is there a mechanism to hide the name, so only scripts are able to see the reference. Maybe this solves my performance issue as well?

I hope you can help me and I expressed myself clearly. Thank you in advance for your help.

Best regards
Timo
2

Hi,

Thanks for your posting and using Aspose.Cells.

Please create a console application replicating your problem and post your statistics. Please use the latest version:
Aspose.Cells for .NET v7.0.3.1


We will investigate this issue and fix it and update you asap.

3

Thank you for the quick responce. It took me a while to extract the relevant code into a seperate project. Find attached to this post the project. The times for creating around 160.000 ranges takes on my machine without threading 49minutes.

Here is a list with times for creating and naming a range. The number specifies how many ranges have been created so far. ApplyName and createName specifies the seconds it takes to create a singe Range:
ApplyName=“0,0019” createName=“0,0012” number="0"
ApplyName=“0,0011” createName=“0,0000” number="5000"
ApplyName=“0,0014” createName=“0,0000” number="10000"
ApplyName=“0,0037” createName=“0,0000” number="15000"
ApplyName=“0,0041” createName=“0,0000” number="20000"
ApplyName=“0,0058” createName=“0,0000” number="25000"
ApplyName=“0,0074” createName=“0,0000” number="30000"
ApplyName=“0,0087” createName=“0,0000” number="35000"
ApplyName=“0,0092” createName=“0,0000” number="40000"
ApplyName=“0,0068” createName=“0,0000” number="45000"
ApplyName=“0,0102” createName=“0,0000” number="50000"
ApplyName=“0,0095” createName=“0,0000” number="55000"
ApplyName=“0,0089” createName=“0,0000” number="60000"
ApplyName=“0,0159” createName=“0,0000” number="65000"
ApplyName=“0,0159” createName=“0,0000” number="70000"
ApplyName=“0,0179” createName=“0,0000” number="75000"
ApplyName=“0,0136” createName=“0,0000” number="80000"
ApplyName=“0,0203” createName=“0,0000” number="85000"
ApplyName=“0,0151” createName=“0,0000” number="90000"
ApplyName=“0,0196” createName=“0,0000” number="95000"
ApplyName=“0,0235” createName=“0,0000” number="100000"
ApplyName=“0,0155” createName=“0,0000” number="105000"
ApplyName=“0,0242” createName=“0,0000” number="110000"
ApplyName=“0,0199” createName=“0,0000” number="115000"
ApplyName=“0,0281” createName=“0,0000” number="120000"
ApplyName=“0,0294” createName=“0,0000” number="125000"
ApplyName=“0,0308” createName=“0,0000” number="130000"
ApplyName=“0,0256” createName=“0,0000” number="135000"
ApplyName=“0,0345” createName=“0,0000” number="140000"
ApplyName=“0,0299” createName=“0,0000” number="145000"
ApplyName=“0,0368” createName=“0,0000” number="150000"
ApplyName=“0,0233” createName=“0,0000” number="155000"
ApplyName=“0,0389” createName=“0,0000” number="160000"

I hope this help you identifiering the issue.

Best regards
Timo

4

Hi,

Thanks for your sample application and the statistics. We will look into them and fix the problems if possible and found any.

We have logged this issue in our database and we will update you asap.

This issue has been logged as CELLSNET-40121.

5

Hi,

Please download: Aspose.Cells for .NET v7.0.4.2

We have improve the performance of adding named range.

6

The issues you have found earlier (filed as CELLSNET-40121) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.