Changes

Jump to: navigation, search

Using an Excel Template for List View Export Results

749 bytes removed, 20:30, 20 July 2017
updating categories
# Next to the "SmartFolder" field, click on the {{LookupButton}} button and select the [[SmartFolder]] in which you have uploaded your spreadsheet.
* This feature can be used in conjunction with the Now, when you export your [[Positioning Exported List View Results in your Excel SpreadsheetOverview|list view]] feature., the following screen will appear:
{{MSExcelSettingsSelectAFile}}
* The "Start Location" field determines the starting position of your list view results (the "data").* The "Query String Location" field determines the starting position of the search criteria currently selected to filter your list view results (the "metadata"). If there are multiple files in your list view is not filteredSmartFolder, select the Query String will be blank.* The default setting is 0;0;0 for both fields. This means that spreadsheet you wish to use as your list view results will be exported, with the topmost, rightmost value appearing in template and click the first worksheet, in cell A1{{SubmitButton}} button.
Note: The syntax for both the "Start Location" and "Query String Location" fields is ''worksheet'';''column'';''row'' The numbering begins at zero, so the first worksheet, first column or first row would * This feature can be referenced used in conjunction with a 0, as opposed to 1. Therefore, if you wanted either the list view results or the metadata to be placed [[Positioning Exported List View Results in the third worksheet of your Excel file, starting in cell B4, you would enter ''2;1;3'' The first worksheet, cell A1 would be ''0;0;0'' {{SelectAFile}}{{SmartFolders}}Spreadsheet]] feature.
{{ListViewFooter}}
* [[Positioning Exported List View Results in your Excel Spreadsheet]]
[[Category:Document Generation]]
Smartstaff, administrator
686
edits

Navigation menu