OfficeUtils - Overview

Go to List

Try Now

Web

24 ratings

0 reviews

1344

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

Component Consumers

Weekly Downloads

Related Components

Simple to use html to pdf/image converter. Based on wkhtmltopdf (https://wkhtmltopdf.org/)

6140

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.

4841

Create amazing native mobile applications using this fully integrated UI framework for OutSystems, with dozens of UI patterns ready to use.

10021