• State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 5 subscribers
  • Views 4547 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Plug-Ins

Excel Capabilities of Appian

GauravSingh
A Score Level 2

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
  • 0
    A Score Level 2

    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

  • 0
    A Score Level 2
     in reply to ankitab0001

    Hi

    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

  • 0
    A Score Level 2
     in reply to GauravSingh

    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>

Reply
  • 0
    A Score Level 2
     in reply to GauravSingh

    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>

Children
No Data

© 2024 Appian. All rights reserved.