OfficeUtils
Stable Version 3.0.0
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 
Related Components
OutSystems UI Mobile
OutSystems R&D
Create amazing native mobile applications using this fully integrated UI framework for OutSystems, with dozens of UI patterns ready to use.
7364
OutSystems UI Web
OutSystems R&D
Create amazing web responsive applications using this fully integrated UI framework for OutSystems, with dozens of UI patterns ready to use.
1280
Customer App Template
Labs
Accelerate the creation of a customer app, with glossy UI and business Logic. This component is not supported. Learn more on the Silk UI Website.
1477
More from Bruno Gonçalves
Offline Apps
Offline Apps Team
The Offline Apps component allows you to add offline capabilities to your OutSystems responsive application. Click here to see how you can use this component for responsive applications.  Learn how to build offline mobile apps with Outsystems.
1938