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
Following are the steps to create XML based formatted excel file.
<?xml version="1.0"?>
<?xml version=" & char(34) & "1.0" & char(34) & "?>
Template: Template.
New document name: NewExcelFileFromTemplate
Save in folder: KC Folder.
input: =rule!DR_UT_XML()
We have similar requirement in our project, did this solution resolved your issue?
please use the plugin at https://community.appian.com/b/appmarket/posts/excel-tools
smartservice : Export SQL data to Excel
This smart service take template as 1 of the inputs.
this could be a solution for your issue