Excel Capabilities of Appian

Hi All,

I have immediate requirement in my project where we need to read Excel files in Appian( recieved via email or file upload field).

Then using these files we have upload the data in some excel template which have some predefined formulas. Along with this some pivot charts are also being created, and vLookup is also being used.

Also let me know if we can perform validation of data that is there in the excel.

Kindly help me with all the capabilities of appian related with excel so that i can plan for development accordingly.

Thanks,

Gaurav Singh

  Discussion posts and replies are publicly visible

Parents Reply Children
  • Save your excel template as zip file--> extract the zip into a folder--> go to the xl folder inside the main folder --> look for the workbook.xml file --> add the property fullCalcOnLoad ="true" (Look for the below sample code) and save the file--> Go back to the main folder and zip all the folders and files (_rels, docPrps, xl, [Content_Types].xml) --> Save that new zip file as xlsx/xls file format and use that to upload in Appian.

    You have to do this every time you do any modifications in the template

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x15" xmlns:x15="http://schemas.microsoft.com/office/spreadsheetml/2010/11/main"><fileVersion appName="xl" lastEdited="6" lowestEdited="4" rupBuild="14420"/><workbookPr filterPrivacy="1" defaultThemeVersion="124226"/><bookViews><workbookView xWindow="240" yWindow="105" windowWidth="14805" windowHeight="8010"/></bookViews><sheets><sheet name="Payment Claim Summary" sheetId="1" r:id="rId1"/></sheets><calcPr calcId="152511" fullCalcOnLoad ="true"/>
    </workbook>