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
Parents
  • 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

Comment
  • 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

Children
No Data