Is there a Recomended best practises of Aspoe.cells

Hi all,

We use aspose extensively in our application. Since we generate large excel files of the order of 30 - 40 MB. I had a couplle of questions so that I generate it in the right way and also if there are any recomended ways of doing it. Thanks in advance.

1. Any recommended way of generating a large Excel file (ideally without keeping the full Aspose worksheet/data in memory the entire time during the generation process).

2. Also its been well over 2 years since we up garded the aspose dll's. Would there be any significant changes that i have to make to my code in order to make the upgrade work with my code. Also are there any significant benefits with excel 2007 support and with regard to any other.

Hi,

1 - You can partially load worksheets. Please see Load only Specific Sheets in a Workbook. Please try it on our latest Aspose.Cells
for .NET v5.3.2.4.


2 - Please see this post.

Hi,

1) Also, you may check the document for your reference if it works for your need.
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/load-only-specific-sheets-in-a-workbook.html

Thank you.