It's very slow when I use Jopendocument to load ods,

[booster]

I'm a java developer and I use Jopendocument's jar for my work, but I found it very quick when I parse the file saved by libreoffice. Very slow when I use files saved by Microsoft Excel, I use the following API.
    SpreadSheet document = SpreadSheet .createFromFile(file);
     Int count = document.getSheetCount();
     For (int i = 0; i < count; i++) {
     Sheet sheet = document.getSheet(i);
 }

Can someone give me some advice? I will be extremely grateful.

[Guillaume Maillard]

Hi,

I'm not aware of such issue.

In order to reproduce/fix it, could you send us a tempate and a sample java app ?

Regards,

Guillaume

--

---
You received this message because you are subscribed to the Google Groups "jOpenDocument" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jopendocument+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[booster]

Hi,

Thank you very much for your reply.
I have uploaded my ods files. If you have any further questions, please feel free to contact me.

Thanks,
Jay

在 2018年4月5日星期四 UTC+8上午1:24:55，guillaume...@gmail.com写道：

To unsubscribe from this group and stop receiving emails from it, send an email to jopendocumen...@googlegroups.com.

[booster]

在 2018年4月5日星期四 UTC+8上午1:24:55，guillaume...@gmail.com写道：

Hi,

To unsubscribe from this group and stop receiving emails from it, send an email to jopendocumen...@googlegroups.com.

[Guillaume Maillard]

Hi,

Sorry for the delay, the reason of the "slow" processing  is quite simple, 

your "test.ods" file has 3 sheets of 16384 columns and 1048576 rows.

It takes time to create them in memory...

Please report this bug to Microsoft. Their ODS export is buggy.

Regards,

Guillaume