• State Verified Answer
  • Replies 4 replies
  • Subscribers 8 subscribers
  • Views 4166 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Export excel file from database table and then make few columns non-editable, hidden and few columns have drop down with pre-populated list of values

Abhay Dalsaniya
Certified Lead Developer

We have a use case to export excel file from database table and then make few columns non-editable, hidden and few columns have drop down with pre-populated list of values.

It seems Appian deprecated most of the excel related plugins which used to take excel templates and achieve above mentioned functionalities. The existing OOTB Appian plugins directly deals with database as a plain excel read/write.

Any possibilities / work around to to make columns non-editable, hidden and drop down values after data is exported to excel.

  Discussion posts and replies are publicly visible

Parents
  • +1
    Certified Lead Developer

    Following are the steps to create XML based formatted excel file.

    1. Manually create excel with required formatting.
    2. Save as xml.
    3. Open xml file in text editor.
    4. Copy XML code in Appian expr rule - rule!DR_UT_XML().
    5. Replace " with - "& char(34) &"

                  <?xml version="1.0"?>

                  <?xml version=" & char(34) & "1.0" & char(34) & "?>

    1. Cover entire code in "".
    2. Create new .xls file (Template) and upload to KC.
    3. Write -> ###input### in cell A1.
    4. Create PM.
    5. Insert node -> "Text Doc from Template".
    6. Provide following configuration in template:

                  Template: Template.

                  New document name: NewExcelFileFromTemplate

                  Save in folder: KC Folder.

                  input: =rule!DR_UT_XML()

     

  • 0 in reply to Abhay Dalsaniya

    We have similar requirement in our project, did this solution resolved your issue?

Reply Children

© 2024 Appian. All rights reserved.