Created on 12 December 2014
icon_unfollowing
Login to follow
officeutils

OfficeUtils

Stable version 5.0.7 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded on 8 Mar (11 days ago) by 
officeutils

OfficeUtils

Details
Provides advanced export capabilities to Excel and Word.
Read more

About

OfficeUtils provides advanced export capabilities to Excel and Word documents. It allows to manipulate and generate a document based on a template included in the Resources folder. The document content is manipulated using a set of server actions available in OfficeUtils Service module, called helpers.

Built using NPOI library (https://github.com/nissl-lab/npoi).


Word export features list:

  • Template based export.
  • Replace text placeholders on the template with text and pictures.
  • Populate template tables with data.


Template example


Expected generated result



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


Template example



Expected generated result



We advise to download and install the component demo, as it provides implementation examples of the several OfficeUtils usage scenarios.

Release notes (5.0.7)

Improved picture display size accuracy in Excel export.

License (5.0.7)
Reviews (3)
by 
2022-10-26
in version 5.0.5
The documentation is very, very helpful. That is what gives it the fifth star  
by 
2022-10-04
in version 5.0.5
Top level component! And demo App helps a lot to understand how it works. Thanks for sharing
by 
2022-09-16
in version 5.0.5
Works as described and expected!
Swift response by the developers (Bruno Gonçalves) when I needed help to understand an issue.
Recommend its usage :)
Category
Functional libraries & utilities, Files & documents
Tags
Support options
This asset is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from  who created this asset.
Dependencies
OfficeUtils has no dependencies.
Application Objects
OfficeUtils has 2 AOs.
Team
Compatible with
Version 11
Database:
All
Asset consumers
No consumers yet.
Weekly downloads