Spreadsheet Viewer

Technical Support Apryse SDK
1

Product:

Product Version:

Please give a brief summary of your issue:
(Think of this as an email subject)
Spreadsheet Viewer Types in Apryse 11.5

Please describe your issue and provide steps to reproduce it:
(The more descriptive your answer, the faster we are able to help you)
The types are not updated for the spreadsheet viewer. I want to be able to extract all the data from the spreadsheet into a 2d array. How do I do it? Typescript React

Please provide a link to a minimal sample where the issue is reproducible:

1 Like
2

Hello, I’m AiRon, an automated tech support bot :robot:
While you wait for one of our customer support representatives, I can help you with your question.


It seems like you’re trying to extract data from a spreadsheet into a 2D array using Apryse’s PDF software APIs in a TypeScript React environment. The Spreadsheet Viewer component might not have updated types, but you can still work with the available API to achieve your data extraction needs.

Some things you can try:

  • Use the getSheetData function from the Spreadsheet Viewer API to retrieve the data from the spreadsheet.

  • Transform the retrieved data into a 2D array using JavaScript array manipulation methods.

  • Ensure that your TypeScript setup is correctly configured to handle any missing types by using any or creating custom type definitions if necessary.




Here are some resources that might help you:



Hopefully, this helps you solve your problem while you wait for a human to get back to you.

1 Like
3

Hello Neel,

The types are not updated for the spreadsheet viewer.

Could you provide an example of this? Do you have a code snippet?

I’ll look into how you can extract all the text data from the Excel viewer and update you.

Best Regards,
Darian

1 Like