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
Hi, I would take a look at this recent post ...
https://community.appian.com/discussions/f/data/18201/reg-readexcelsheet-function
It uses the readexcelsheet function that comes with the Excel Tools plugin from the App Market, this would be a good place to get started.
Thanks Dai Williams,
This will help me up with the validation part.
Any input on macros, pivot or vlookup will be appreciated.
Thanks
Hi
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
Hi ankitab0001
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"/> </workbook>