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.
Did you try altering the properties of workbook.xml file of the excel template and then upload it? This ensures excel performs all calculations based on the formulas in Appian
Can you please elaborate on it like how to alter the properties of workbook.xml.
It would be really helpful if u can share some detailed steps
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"/>
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.