Changes

Jump to: navigation, search

Using an Excel Template for List View Export Results

1,217 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 {{SubmitButton}} 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

Navigation menu