Plug-in (Function & Smart Service)Free

SQL To Excel Smart Service

by Xebia USA Inc

Description

  1. Generating Dynamic Budget Reports using multiple database tables using SQL to Excel Smart Service.
  2. Import Financial Budget of the Organization right from the Excel Sheet in a Single Step.
  3. Use Predefined Excel templates to apply styling on the generated sheet.

Features

Ability to Export SQL Data in a predefined template for dynamic reports Import Excel Data in CDT Excel Change Sheet Order Delete Excel Sheet Multiple templates can be associated with multiple worksheets of a single workbook

Release notes

Fixes;-

  1. Appian 25.4 missing alias names.
  2. Updates for the MariaDB Connector/J : 3.5.3 (alias names)
Version history (8)

2.1.4

Fixes;-

  1. Appian 25.4 missing alias names.
  2. Updates for the MariaDB Connector/J : 3.5.3 (alias names)

2.1.3

Fixes;-

  1. Appian 25.3 missing alias names.
  2. Missing sheets from templates in the exported version.
  3. Updates for the MariaDB Connector/J : 3.5.3 (alias names)

2.1.2

Fixes;-

  1. Appian 25.3 missing alias names.
  2. Missing sheets from templates in the exported version.

2.1.1

Fixes;-

  1. Appian 25.3 missing alias names.
  2. Missing sheets from templates in the exported version.

2.0.1

Vulnerability Fixes (updated all jar files to the latest version) and latest Appian version fixes (Changed getColumnName() to getColumnLabel() method in all instances. )

2.0.0

Vulnerability Fixes

1.4.0

Fixed Review Comments

  • Added try-with-resources for connections.
  • Closed some connections in final blocks.

===== Fixed the reported vulnerabilities in the plugin as per the vulnerability report:

  1. Update the following Libraries to the latest versions a) commons-beanutils b) commons-io c) commons-lang d) commons-math e) poi f) poi-ooxml g) xml-beans
  2. Added New lib that is compatible with the new version. a) commons-collections b) commons-compress c) poi-ooxml-lite
  3. Remove the deprecated setter function that sets cell style

** This is fairly urgent as this blocks some of our critical multiple applications deployment, hence a quick turn-around time on this is appreciated.

1.3.1

Updated libraries for log4j vulnerability