We are evaluating Aspose.Cells for .NET and have run into some performance issues. Our data is in custom objects, however they are grouped using LINQ. There are about 17,000 rows with 25 columns (within this set there are over 7000 groups).
Here is what we have observed:
- In order to properly traverse our records, we iterate through all groups and then all the items in each group and update the cell values using sheet.Cells[x,y].PutValue(data).
- We believe we are following the best practices mentioned in the docs and this forum (for example, setting values left to right / top to bottom, creating one or two Style objects and setting them to cells as needed, etc).
- This process takes 10-11 minutes (Core 2 Duo 2.8ghz)
- When we don’t group our data and use the ImportCustomObjects method, it completes the same amount of data in under 20 seconds.
However, we can’t easily use the ImportCustomObjects method because we insert an extra row with the group name before each group’s items. So my question is, how do we achieve the speed of your Import methods, while still having more control over the imported data and formatting? Can we use multiple threads when setting cell values? Is there anything else we can do to improve performance?
Thanks!