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 colour can also be customised
Anonymous
Parents

  • I tried to pass 4 sheets and 4 query rules(same statement). I am getting [SQL command not properly ended] error. Is there any specification to consider while writing sql statement. I was able to get document for one sheet. For multiple sheet I am getting this error.

Comment

  • I tried to pass 4 sheets and 4 query rules(same statement). I am getting [SQL command not properly ended] error. Is there any specification to consider while writing sql statement. I was able to get document for one sheet. For multiple sheet I am getting this error.

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