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 
Related Components
Html2PdfConverter
Guilherme Pereira
Simple to use html to pdf/image converter. Based on wkhtmltopdf (https://wkhtmltopdf.org/)
6115
Advanced Excel
Carlos Freitas
Advanced Excel integration with the export/import of Excel files. Enables data formatting, even automatic creation of Excel charts. This enables writing of binary multi-sheet excel-files without the use of an office installation.
4835
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.
9951
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.
1987