Apryse WebViewer cannot open large Excel files (50MB)

Technical Support WebViewer
,
1

WebViewer Version: “@pdftron/webviewer”: “^10.6.0”
Do you have an issue with a specific file(s)?

image
image1477×1389 258 KB

Can you reproduce using one of our samples or online demos?
Are you using the WebViewer server? Yes, “@pdftron/webviewer”: “^10.6.0”,
Does the issue only happen on certain browsers? Edge, Chrome
Is your issue related to a front-end framework? No, WebViewer cannot load a large file
Is your issue related to annotations? No

Please give a brief summary of your issue:
I have a large Excel file, approximately 50MB in size. As shown in the picture, the Excel file contains many rows and multiple sheets (6-7 tabs). Currently, I am using Apryse WebViewer on Next.js and have tried to increase the heap size, but it still cannot open the file. I used the code inst.Core.setEmscriptenHeapSize(30 * 1024 * 1024);. Is this an issue or a limitation of Apryse WebViewer?

2

Hello Dung,

Thank you for contacting WebViewer Forums.

You can allocate more cell count resources for larger excel documents such as this one. The TRN_MAX_EXCEL_CELL_COUNT property is currently defaulted at 250,000 unique cell counts. To configure the property, please review the guide here: Wv-server-config | Apryse Documentation

Regards,
Luke

3

Thanks for your support, Luke. I want to reconfirm that I do not have a WebViewer server, and I am trying to view a large Excel file.

Screenshot 2024-08-30 at 11.45.40 PM
Screenshot 2024-08-30 at 11.45.40 PM666×726 103 KB

4

Hello Dung,

Thank you for clarifying.

Are you able to provide the document with this issue? You may have to send a link to a drive if the file is too large to attach.

Regards,
Luke

5

There is nothing special in the file. Generally, it contains over 1,000,000 rows, as shown in the picture.

image
image1477×1243 197 KB

6

Hello Dung,

Handling very large Excel files efficiently can be challenging due to the significant amount of data processing involved. It processes for each unique cell so if you have over 1,000,000 rows and multiple tabs, it is expected to take a long time but the file should still eventually load.

Can you try loading on our demo showcase here? It should take some time but still load: https://showcase.apryse.com/

I would also suggest server-side processing can significantly improve performance for large files.

Regards,
Luke

7

Thanks for your support, Luke. I will consider using server-side rendering