About

OfficeUtils provides advanced export capabilities to Excel and Word documents. It allows to manipulate and generate a document based on a template included in the Resources folder. The document content is manipulated using a set of server actions available in OfficeUtils Service module, called helpers.

Besides the export capabilities, OfficeUtils also provides functionality for Excel and Word documents content extraction.

Built using NPOI library (https://github.com/nissl-lab/npoi).

Word export features list:

• Template based export.
• Replace text placeholders on the template with text and pictures.
• Populate template tables with data.

Template example

Expected generated result

Excel export features list:

• Template based export (optional).
• Write data on multiple sheets and sheet coordinates.
• Use as input the output of RecordListToExcel or specify each one of the cell values individually.
• Write data on the platform default format or keeping the format specified on the template.
• Insert images.
• Sheets cloning.
• Cells merging.
• Apply styles to cells (colors, borders, and alignments).

Template example

Expected generated result

We advise to download and install the component demo, as it provides implementation examples of the several OfficeUtils usage scenarios.