Embed Image into Excel

Provides a custom smart service and custom expression function to embed one image or multiple images in an Excel sheet.

The following types of configurations are supported

  1. One cell, one image
  2. One cell, multiple images
  3. Multiple cells, one image
  4. Multiple cells, multiple images
  5. Width configuration of row where image will  be rendered, margin for image (1-5) and image scale percentage (20 to 100 %) for each individual image with respect to width provided.
Anonymous
  • - any possibility to update this plug-in?  It seems to not be working for anyone currently (just tried fresh in 19.4 and I'm receving almost exactly the same error as the previous comments describe).

  • Hi

    We are also trying to use Embed Image into Excel smart service in 19.4 and getting below error:

    Exception: java.lang.IllegalStateException: Expected BEGIN_ARRAY but was BEGIN_OBJECT at line 1 column 43

    JSON Input:

    {
    "width":1000,
    "padding":3,
    "imageAnchors":{
    "col1":2,
    "row1":2,
    "col2":3,
    "row2":3
    },
    "imageDocument":{
    "imageDocumentID":311790,
    "sizePercentage":80
    }
    }

    any pointers regarding this issue

  • Hi All,

    I am trying to use Embed image to Excel Functionality in appian 19.1 version, where-in  we want to download the image present in grid to excel sheet

    I checked in both cloud and on premises environment.

    When trying to use this particular function inside an expression rule/ process model we get the error as mentioned below

    “Exception: java.lang.IllegalStateException: Expected BEGIN_ARRAY but was BEGIN_OBJECT at “ line 1 column 43”

    I have passed the data in json format below

    "{"width":1000,"padding":3,"imageAnchors":{"col1":2,"row1":2,"col2":3,"row2":3,"imageDocument":{"imageDocumentID":167575,"sizePercentage":80}}

    I have given proper excel template and destination folder, sheet ID and Document Name

    Please help us