I am having a performance issue. Current version I am using is 8.0.2.0 trial version. Right now i am load a excel2007.xlsx file and using this code to convert it.
static void Main(string[] args)
{
string fileName = “excel2007.xlsx”;
SpreadsheetDocument doc = null;
doc = FileConverter(fileName);
Console.ReadLine();
}
static public SpreadsheetDocument FileConverter(string fileLocation)
{
LoadOptions loadAuto = new LoadOptions(LoadFormat.Auto);
loadAuto.LoadDataAndFormatting = true;
SpreadsheetDocument doc = null;
try
{
Aspose.Cells.Workbook excelWorkBook = new Aspose.Cells.Workbook(fileLocation, loadAuto);
MemoryStream stream = new MemoryStream();
excelWorkBook.Save(stream, SaveFormat.Auto);
doc = SpreadsheetDocument.Open(stream, false);
Console.WriteLine(“It worked”);
}
catch (System.Exception e)
{Console.WriteLine(e.Message);}
return doc;
}
Right now it is taking 12 seconds to do this and I am hoping to change that down to 1 second. Is there any way to speed this process up?
Hi Joel,
Thank you for using Aspose products, and welcome to the Aspose.Cells support forum.
Please use the Memory Optimization Preferences, and see if you can observe notable performance improvements. In case the problem persists, please provide us the template spreadsheet so we could evaluate the problem on our end to suggest you a solution.