About

OfficeUtils provides advanced export capabilities to Excel and Word documents (available for .NET and Java stacks). 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.

Built using NPOI 2.4.1 (.NET stack) and Apache POI 3.11 (Java stack).

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.