Overview

View and edit your excel files. Pluggable widget based on the x-spreadsheet library that allows you to visualize and edit your excel data directly from your Mendix web app. Current features include:

• Cell formulas.
• Edit vs. view-only mode.
• A toolbar to customize data.
• Possibility to export/download file.
• Multiple sheets. 

The widget is based on this library.

Demo project:

• Mendix app running on the cloud
• Mendix demo module (.mpk)

Documentation

Data Spreadsheet Mendix Pluggable Widget

A Mendix widget to view and edit excel files / spreadsheets based on https://github.com/myliang/x-spreadsheet.

Features

View and edit your excel files. Pluggable widget based on the x-data-spreadsheet library that allows you to visualize and edit your excel data directly from your Mendix web app. Current features include:

• View / Edit mode;

• Multiple sheets;

• Cell formulas available;

• Custom toolbar;

• Possibility to show download and/or save button(s);

• Possibility to add an After Save activity, such as a nanoflow to show a success message;

• Export settings fully customizable;

• Customize css. The spreadsheet is wrapped by the id below:

  • #gridctr

Usage

1. Add a dataview that fetches the .xlsx file you wish to display/edit.
2. Inside the dataview, add the x-spreadsheet widget.
3. Custumize it. Make it editable/view-only; Decide if you want to show the Save/Download button. Define a width margin if needed.
4. In case you want to export (save/download), define the export options.

Demo project

• Mendix app running on the cloud
• Mendix demo module (.mpk)
• Marketplace widget

Issues, suggestions and feature requests

• ⚠️ Performance is a problem when handling large files. In part, this is a limitation of the SheetJs free version. The Pro version might be a solution.

• ⚠️ Strange behaviour with the spreadsheet's horizontal scrollbar when using Mozilla Firefox. This seems unrelated to this widget's logic as per this Stack Overflow post.

• ⚠️ This widget contains some limitations, namely, the converstion method ignores the styles - "The underlying grid component includes many additional features that work with SheetJS Pro." - .

• 🙌 Feel free to suggest us new features or report bugs.