Changes

Using an Excel Template for List View Export Results

1,185 bytes added, 20:30, 20 July 2017
updating categories
{{ListViewHeader}}
 
When exporting to Excel has been [[Exporting List View Results to Microsoft Excel|enabled]] for your [[List View Overview|list view]], you can also tell the system to use an Excel file as a template into which your results will be exported.
 
<!--{{ExportListViewPage}}
-->
 
To enable this feature:
# Create an Excel spreadsheet you wish to use for a list view export template.
# [[Uploading a File – Step by Step|Upload]] the Excel file to a [[SmartFolder]].
# Go to the [[Accessing the List View Configuration Page|list view configuration page]].
# Click into the list view for which you wish to enable exporting.
# Click on the "Export" tab.
# Next to the "SmartFolder" field, click on the {{LookupButton}} button and select the [[SmartFolder]] in which you have uploaded your spreadsheet.
 
* Now, when you export your [[List View Overview|list view]], the following screen will appear:
{{SelectAFile}}
 * If there are multiple files in your SmartFolder, select the spreadsheet you wish to use as your template and click the {{SmartFoldersSubmitButton}}button. * This feature can be used in conjunction with the [[Positioning Exported List View Results in your Excel Spreadsheet]] feature.
{{ListViewFooter}}
* [[Positioning Exported List View Results in your Excel Spreadsheet]]
[[Category:Document Generation]]
Smartstaff, administrator
686
edits