Vaadin Spreadsheet with JPAContainer


I’m developing an application which uses vaadin spreadsheets, so I want to know if there is a way to fill the spreadsheet data using JPAContainer as we do with tables.

Thank you.

The Spreadsheet does not use Container data sources. What you need to do is to create an XLSX file using the Apache POI library and give that file (or stream) to the Spreadsheet. There are several ways to create the file, but the easiest might be just to query your DB manually and fill the data yourself using the POI API.

Alternatively, you could use the Grid (but you’ll lose some features, e.g. always-on editing and formula support).