I know this is a tricky one to answer as I can't send the actual 2007 spreadsheet (due to compnay confidentiality) but I've having some performance problesm with opening a fairly large spreadsheet.
I have a spreadsheet which is 1.7MB in size and contains about 30 worksheets. It's used for insurance rating and has alot of formulae and VBA code as well as a large number of named ranges. Our application will populate the named range fields to create a new spreadsheet of the original template.
I have the spreadheet as a byte array and wrap a memeory stream around it to open it via the workbook.open method. Here is a methos I use to open the spreadsheet:
private static Workbook GetWorkbookFromStream(Stream stream)
logger.Debug("Create workbooking (Timing)");
Workbook workbook = new Workbook();
logger.Debug("Open the workbook (Timing)");
logger.Debug("Return the workbook (Timing)");
It takes 11 seconds between the Open the workbook and Return the workbook log statements which is too long for our users as this happens between page requests in our application.
As I say, I know it's difficult to track down without the xls but are there any tips on how to speed this up? I'm using Aspose.Cells 18.104.22.168,