Example: Using the Export to Microsoft Excel Action (CAD)

although the action is called export to microsoft excel , you can also export to a comma separated value (csv) or xml spreadsheet you can use the export to microsoft excel action to export all or some of the field values from a business object to a microsoft excel, csv, or xml spreadsheet for example, you can export some of the field values from a change record to a microsoft excel spreadsheet automatically applies sorting settings to any records that you export to microsoft excel, csv, or xml including from the dashboard and the saved searches overview page when you use the export to microsoft excel action to export all or some of the field values from a business object to a microsoft excel, csv, or xml spreadsheet, the file is sorted with both the simple sort order and the multisort settings that you previously set in the list see export to microsoft excel action docid\ pnhrip02cilsoukjuazdy from the configuration console, click build > automation tools > quick actions to open the actions manager workspace the list of business objects that have actions appears click add/edit for a business object the actions center appears click the create new actions tab click export to microsoft excel from the list of options enter the following information field description enter action name a name for this action enter action description an optional description enter category a category select from the drop down list publish to the roles that need access to this template information entered in the description field of an incident record does not retain line breaks when you use the export to excel action edit, add, or leave the column header and fields to export values as is to import relationships, do the following a under the value expression heading, click the function icon b under the toolbox heading, expand the name of the business object and then expand relationships c double click the relationship business object, then double click the fields header underneath it d select the field to import from the relationship business object e click save click save to save the action