Plug-in (Function & Smart Service)Free

Excel Utility

by Vuram Technology

Description

Looking for a way to copy the sheet of your Excel workbook into a new Excel workbook or finding it hard to combine multiple Excel files into a single workbook with all sheets combined to one file directly in Appian? Then here you have the Excel Utility plug-in that brings you two helpful smart services.

Note: Requires a valid Aspose Cells for Java license. Use the link https://purchase.aspose.com/temporary-license to get a temporary license. The complete license can be bought after testing the functionality. Check out the KB article for Aspose Plug-ins FAQ.

Features

  1. Copy Excel Sheet - copy sheets of one workbook to another workbook
  2. Combine Excel Sheet - combine multiple Excel files into a single file containing sheets of all the combined files.
  3. Read Excel Sheet- The Excel document to read sheet with different filter functions(Number of rows, Sheet results with Null or without Null). Note: Only .xlsx files are supported

Release notes

V4.2.3 Fixed issue in Copy excel Smart service

Version history (12)

4.2.2

Bug fix in readexcelsheetwithfilter()

4.2.1

Security patch attached

4.2.0

Added new Smart service Insert image into Excel.

4.1.0

  1. Added xls file support to readexcelsheetwithfilter() function.
  2. Security patch updated.

4.0.3

Security patch attached

4.0.2

  1. Fixed a library loading issue.
  2. Bug fixes.

4.0.1

Security patch updated

v4.0.0

Updated the parameters of the readexcelsheetwithfilter() function.

v3.0.2

Security Patch attached

v3.0.1

Security patch updated

v3.0.0

Added read excel sheet with filter function

2.0.0

This version is acombination of two smart services:

  1. Copy Excel Sheets smart service
  2. Combine/Merge excel file smart service

Resources