Advanced Excel

Stable Version 2.1.23 (O11)
Also available for 10, 9.1, 9.0, Older
Published on 27 August 2019 by 
Created on 13 May 2013
What’s new (2.1.23)
  • Added functionality to create a new workbook with multiple sheets
    • Specify the number of sheets, with a name for the first sheet, or
    • Specify a list of sheet names
  • Updated the Demo App
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.
Read More

Feature List Write of data-sets or single cells Reading of each cell, interpreting different data types Open an existing excel workbook Create new workbooks Manage worksheets Save the workbook to disk, or download Creation of Named Ranges Workbook / Worksheet password protection Main Benefits Enables advanced export of office spreadsheets using a base spreadsheet that can have multiple sheets, branding and several formatting options (done in the excel base file) Create named ranges with value to validate data input System Requirements and Limitations Works with office 2007/2010 format Only a small subset of the library is being used; Notice: This component takes advantage of private and undocumented Platform APIs, which can change without notice. As a result, this component may unexpectedly break as the Platform is upgraded. We advise proper testing to ensure that your applications continue to work as expected when upgrading/patching the Platform.

Reviews (2)
15 Oct
in version 2.1.23
You have written DOCUMENTATION! Thanks that is very very important 
in version 2.1.23
Great tool.
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 Carlos Freitas who created this component.
Advanced Excel has no dependencies.
Component Consumers
No consumers yet.
Weekly Downloads