converting to excel and downloading a record type with one click of a button

I dont think thats possible. That is a built in functionality which appears when using record as the source in a grid. You have to build the functionality manually.

You could create a Web API which creates that Excel file. Then use a link to point to this API. With a correct setup of HTTP headers in the API, the browser will just download the file.

Hi

To implement a button in an Appian interface that allows users to convert query results or a record type data into an Excel file and then download it with a single click, without using a grid's built-in export functionality, you can indeed follow Stefan Helzle's approach using a Web API.

Web API expample:

/*
Web API Endpoint: 'generateExcel'
Method: GET
*/

/* Query your data */
     local!data: queryEntity(

     entity: cons!MY_RECORD_TYPE, query: a!query())

/* Generate Excel */
      local!excelFile: createExcelFile(data: local!data)

/* Set up response to download file */
     response(
     headers: {
    'Content-Disposition': 'attachment; filename="data.xlsx"', 
    'Content-Type': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
     },
    body: local!excelFile
    )

Interface Button Configuration

a!buttonWidget(
label: "Download Excel",

)