Give us feedback
officeutils
Service icon

OfficeUtils

Stable version 5.0.5 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded on 25 May by 
4.6
 (34 ratings)
officeutils

OfficeUtils

Details
Provides advanced export capabilities to Excel and Word for both .NET and Java stacks.
Read more

About

OfficeUtils provides advanced export capabilities to Excel and Word documents (available for .NET and Java stacks). 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 2.5.5 (.NET stack) and Apache POI 3.11 (Java stack).


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.

What’s new (5.0.5)

Word

  • Increased robustness of the placeholders replacement mechanism.
  • Fixed an issue that prevented images to be exported with their original size.
  • Fixed an issue with the processing of tab characters (\t).


Excel

  • Significant performance improvements in spreadsheet export.
  • Fixed an issue that caused conditional formatting definitions not to be copied when cloning sheets.


Upgraded NPOI to version 2.5.5.

Reviews (3)
26 Oct
in version 5.0.5
The documentation is very, very helpful. That is what gives it the fifth star  
4 Oct
in version 5.0.5
Top level component! And demo App helps a lot to understand how it works. Thanks for sharing
16 Sep
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 :)