OfficeUtils

Stable Version 5.0.4 (O11)
Also available for 10, 9.0
Published on 18 December 2020 by 
Created on 12 December 2014
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)
Category
Functional libraries & utilities, Files & documents
Tags
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Bruno Gonçalves who created this component.
Dependencies
OfficeUtils has no dependencies.
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
Component Consumers
No consumers yet.
Weekly Downloads