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,