Excel Tools

Overview

Provides the following custom smart services and functions for handling data in Excel.

Key Features & Functionality

Smart Services included are:

  • Merge Excel Documents
  • Import CSV to Database
  • Import Excel to Database
  • Load CSV to Database
  • Convert HTML to CSV  
  • Convert Excel to CSV
  • Encrypt Excel with Password

Functions included are:

  • Read Excel File Paged
  • Read Excel Cell by Name
  • Read Excel Cell by Number
  • Query Appian Logs
  • Export Datasubset to Base64
  • Validate Document Headers
Anonymous
Parents
  • Hi,

    we are still on the 1.8.3 version of this plugin and it is working fine till 23.4.

    But we are seeing the Export SQL to Excel smart service is giving below error since we upgraded to 24.2. All other smart services of the plugin are working fine on 24.2.

    com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.export.general=The following error was raised by the Export to Excel function: class org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream cannot be cast to class java.util.zip.ZipFile$ZipFileInputStream (org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream is in unnamed module of loader org.apache.felix.framework.BundleWiringImpl$BundleClassLoader @ea66ef5; java.util.zip.ZipFile$ZipFileInputStream is in module java.base of loader 'bootstrap')]
    at com.appiancorp.suiteapi.process.exceptions.SmartServiceException$Builder.build(SmartServiceException.java:145)
    at com.appiancorp.ps.exceltools.smartservice.export.ExportSqlToExcel.createException(ExportSqlToExcel.java:416)
    at com.appiancorp.ps.exceltools.smartservice.export.ExportSqlToExcel.run(ExportSqlToExcel.java:103)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.lambda$call$0(DefaultActivityExecutor.java:136)
    at com.appiancorp.plugins.PluginUsageLogger.runWithPluginInformation(PluginUsageLogger.java:54)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:136)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:130)
    at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:28)

Comment
  • Hi,

    we are still on the 1.8.3 version of this plugin and it is working fine till 23.4.

    But we are seeing the Export SQL to Excel smart service is giving below error since we upgraded to 24.2. All other smart services of the plugin are working fine on 24.2.

    com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.export.general=The following error was raised by the Export to Excel function: class org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream cannot be cast to class java.util.zip.ZipFile$ZipFileInputStream (org.apache.poi.openxml4j.util.ZipSecureFile$ThresholdInputStream is in unnamed module of loader org.apache.felix.framework.BundleWiringImpl$BundleClassLoader @ea66ef5; java.util.zip.ZipFile$ZipFileInputStream is in module java.base of loader 'bootstrap')]
    at com.appiancorp.suiteapi.process.exceptions.SmartServiceException$Builder.build(SmartServiceException.java:145)
    at com.appiancorp.ps.exceltools.smartservice.export.ExportSqlToExcel.createException(ExportSqlToExcel.java:416)
    at com.appiancorp.ps.exceltools.smartservice.export.ExportSqlToExcel.run(ExportSqlToExcel.java:103)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.lambda$call$0(DefaultActivityExecutor.java:136)
    at com.appiancorp.plugins.PluginUsageLogger.runWithPluginInformation(PluginUsageLogger.java:54)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:136)
    at com.appiancorp.process.runtime.framework.DefaultActivityExecutor$1.call(DefaultActivityExecutor.java:130)
    at com.appiancorp.common.ContextClassLoaderSwitcher.runInContext(ContextClassLoaderSwitcher.java:28)

Children