Integration of the alaSql Librairy, to export / import Excel
Access the example page https://github.com/Bonitasoft-Community/widget_alaSqlOperation/blob/master/page-pageAlasql.zip
In this page, you have a complete example:
-
you have a list of data in a WidgetDataTable, then the widget creates for you an Excel file. It’s done locally, no call to any server
-
on the opposite, you want to load an Excel File? Widget open it, explore the content and produce a JSON data that you can use to populate your form/page
Repository URL : https://github.com/Bonitasoft-Community/widget_alaSqlOperation