Open workboek file with SpreadsheetML format

Aspose.Cells Product Family
1

Dear All,


When we try to open a SpreadsheetML file aspose starts reading and after one hour the file is still not read completely. When we open thid file ion excel it takes about 30 seconds to read this file.

Code we use to open the file:
var wb = new Aspose.Cells.Workbook(“ICT - ToLarge.xml”);

or

//Specify the LoadOptions
LoadOptions opt = new LoadOptions(LoadFormat.SpreadsheetML);
//Set the memory preferences
opt.MemorySetting = MemorySetting.MemoryPreference;
opt.InterruptMonitor = new InterruptMonitor();
opt.LoadDataAndFormatting = true;
opt.ParsingFormulaOnOpen = false;

FileShare.Read, 4096, FileOptions.Asynchronous | FileOptions.SequentialScan);
var wb = new Aspose.Cells.Workbook(“ICT - ToLarge.xml”, opt);

The file we try to load is attached.

Can you please help us with this. Is there an option we are missing or is this a problem in the software.

Regards,
Leon Broekhuizen
CarWise

2

Hi,


Thanks for the template file and some details.

Probably you attached the wrong file, please provide the SpreadsheetML (.xml) file. The file you attached is an XLSX file. I tested your scenario/ case using the following sample code with your attached file and it works instantly without any delay.
e.g
Sample code:

Workbook workbook = new Workbook(“e:\test2\tstlb.xlsx”);


Also, we recommend you to kindly try our latest version/ fix: Aspose.Cells for .NET v8.4.1.3 if it makes any difference.

Thank you.


3

Hello,


Sorry, I indeed attached the wrong file.
Hereby the correct file.

Regards,
Leon
4

Hi,


Thanks for the template file.

As we already requested you to try our latest version/ fix: Aspose.Cells for .NET v8.4.1.3, it works fine with it. I have tested your scenario/ case using your attached SpreadsheetML file with Aspose.Cells for .NET v8.4.1.3 (please try it) and it works fine.
e.g
Sample code:

Workbook workbook = new Workbook(“e:\test2\tstlb.xml”, new LoadOptions(LoadFormat.SpreadsheetML));


Thank you.

5

Hello,


Yes,
this solved the problem.

Thanks for your support.

Regards,
Leon
6

Hi,


Thanks for your feedback.

Good to know that your issue is sorted out now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

Thank you.