Try Now

Web

4.8

(26 ratings)

0 reviews

1536

Bruno Gonçalves

Created on 12 December 2014

Details

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

Excel export feature 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).

Word export feature list:

Template based export.
Replace text placeholders on the template with text, images and tables.

The module "OfficeUtilsSample" provides implementation examples of the several usage scenarios of this component.

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

What’s new (3.0.0)

Upgrade of the component to OutSystems Version 10.

Added features:

Excel - Possibility of setting the horizontal and vertical alignment for cells.
All the functionality that was available for .NET stack only is now available for the Java stack as well (cloning sheets, merging cells, apply styles to cells).

Reviews (0)

Tags

Excel

Word

Export

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:

10.0.0.402

Database:

All

Stack:

All

Team

Bruno Gonçalves