Aspose.Cells.Workbook - Performance Issue


#1

Hi There,

i am validating Macros, Embedded objects and DDELink in MS Xls file using Aspose.Cells.Workbook class.

when i load smaller file it is fine no issue. but when i load BIG file (more than 30 or 40 MB) i really have performance issue and get Out Of memory issue.

here is my code

var workbook = new Workbook(stream); //Takes long time and throw exception if file size is big (ie. 45MB)

bool isEncryped = info.IsEncrypted;

bool hasMacro = workbook.HasMacro;

bool embeddedObjects = workbook.Worksheets.Any(w => w.OleObjects.Count > 0) ? true : false;

bool isDDELink = ExcelProcessor.IsDDELinkFound(workbook);

Is there any other option aspose provide to validate these items?

Thanks in Advanced…

-Surendra


#2

@andy.a.kuan.wellsfar,

Thank for your query.

Please share your sample file with us for our testing. We will re-create the problem here and provide our feedback after analysis.