excel view in mendix?

0
Hello, I've tried various Excel viewer widgets, but none of them perfectly display Excel functions, background colors, font sizes, and positions. Is there a way to do this?
asked
1 answers
2

Hi,

 

A practical approach is to convert the Excel file into a PDF and display it directly inside Mendix. This method ensures that the document looks exactly like it does in Excel, maintaining all cell alignments, formatting, and visual elements. The process begins by converting the Excel file into a PDF format. This can be done either using a Java action that leverages a library such as Apache POI, Aspose. Cells, or a REST API from an external service that handles Excel-to-PDF conversion. Once the conversion is completed, the generated PDF file can be stored as a System.FileDocument object in Mendix. After saving it, you can easily show the document to users by placing a PDF Document Viewer or File Viewer widget on a page and linking it to that file object.

answered