OfficeUtils

Stable Version 5.0.4 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Published on 18 December 2020 by 
4.6
 (31 ratings)

OfficeUtils

Details
Provides advanced export capabilities to Excel and Word for both .NET and Java stacks.
Read More

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.

What’s new (5.0.4)

Many thanks to the OutSystems Curation Team, who did such a great job in improving OfficeUtils demo and documentation:

  • New and improved demo
  • Documentation improvement
  • Object descriptions improvement
Reviews (0)