search

handsontable / spreadsheet-viewer

Spreadsheet Viewer is a developer-friendly JavaScript tool that lets your users preview Excel files without leaving your web app
https://handsontable.com/spreadsheet-viewer
33 stars 10 forks source link

Is there a way to programmatically query the cell contents for a range? #19

Open RyleySill93 opened 2 months ago

RyleySill93 commented 2 months ago
image

How can I get the cell contents for the highlighted range here? I'd expect something back like [[9.82, 7.57],[155, 296]]. The "cellSelectionChanged" event only returns the coordinates of the selected range, not their actual contents. Since I can copy these values directly out of the spreadsheet viewer instance, I'd expect to be able to get them some other way?

AMBudnik commented 2 months ago

Hi @RyleySill93

The developers who were responsible for managing this project are no longer actively maintaining it, and the product is no longer receiving maintenance or support.

RyleySill93 commented 2 months ago

Hi @RyleySill93

The developers who were responsible for managing this project are no longer actively maintaining it, and the product is no longer receiving maintenance or support.

ah I see - @AMBudnik Do you know if handsontable has a recommended alternative approach for rendering excel files?

AMBudnik commented 2 months ago

There's no built-in plugin or logic for importing Excel files to Handsontable. We operate on JSON files only (as a file type for data load). Our clients are using some XLSX > JSON parsers from Github, but I need to know which of those are recommended. If you only need raw data (without styling and data types) a parser might be a good idea. Otherwise, you'd need to adjust the types of columns (via columns setup) and apply needed styling/formatting separately. If you'd like to have a quick chat about it please contact us at support@handsontable.com