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

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) & "?>

6. Cover entire code in "".
7. Create new .xls file (Template) and upload to KC.
8. Write -> ###input### in cell A1.
9. Create PM.
10. Insert node -> "Text Doc from Template".
11. Provide following configuration in template:

              Template: Template.

              New document name: NewExcelFileFromTemplate

              Save in folder: KC Folder.

              input: =rule!DR_UT_XML()

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) & "?>

6. Cover entire code in "".
7. Create new .xls file (Template) and upload to KC.
8. Write -> ###input### in cell A1.
9. Create PM.
10. Insert node -> "Text Doc from Template".
11. Provide following configuration in template:

              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

Hi Abhay, I have tried your approach but I am not able to create the file properly. I am getting the following error:

Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) A text/xml declaration may occur only at the very beginning of input. Line 2, column 125.
Removed Records: Cell information from /xl/worksheets/sheet1.xml part

could you provide both the XML and XLSX files that worked for you?