OfficeUtils

Stable Version 3.0.0 (O10)
Also available for 9
Published on 26 April 2017 by 
Created on 12 December 2014
Details
Provides advanced export capabilities to Excel and Word for both .NET and Java stacks.
Read More

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)
Category
Reporting, Themes and Templates
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:
10.0.0.402
Database:
All
Stack:
All
Component Consumers
See all 3 consumers
Weekly Downloads