Information
  • Author: Cognizant
  • Type: Plug-in (Function & Smart Service)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 23.4
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Fast Excel Plug-in

Fast Excel Plug-in

Overview

This Smart Service can be used to generate Excel Document from SQL Query. This is an alternative to Smart Services using the Apache POI library. This plugin makes use of Fast-Excel open-source java library and can handle large data sets efficiently by optimising the memory utilisation during the generation of excel file.

Key Features & Functionality

Data Types: SQLSheetData
Smart Services: writeSQLToExcelV1

Features:

  • Generates multi-sheet excel based on CDT data input
  • Column Names are taken from SQL command results (Use column aliases)
  • Supports generation of Password Protected Excel File
  • Supports MySQL and Oracle Database
  • Header column color can also be customized
Anonymous
Parents

  • In the "List of SQL Queries and Sheet Names" - I am passing sheetName = "Test1" and in sqlQuery="SELECT * FROM TEST_TABLE;"

    But I am still getting error as - "... requires a value. Since this node is unattended, you must enter a value during design".

Comment

  • In the "List of SQL Queries and Sheet Names" - I am passing sheetName = "Test1" and in sqlQuery="SELECT * FROM TEST_TABLE;"

    But I am still getting error as - "... requires a value. Since this node is unattended, you must enter a value during design".

Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.