Difference between revisions of "Positioning Exported List View Results in your Excel Spreadsheet"
From SmartWiki
Line 16: | Line 16: | ||
* The "Query String Location" field determines the starting position of the search criteria currently selected to filter your list view results (the "metadata"). If your list view is not filtered, the Query String will be blank. | * The "Query String Location" field determines the starting position of the search criteria currently selected to filter your list view results (the "metadata"). If your list view is not filtered, the Query String will be blank. | ||
* The default setting is 0;0;0 for both fields. This means that your list view results will be exported, with the topmost, rightmost value appearing in the first worksheet, in cell A1. | * The default setting is 0;0;0 for both fields. This means that your list view results will be exported, with the topmost, rightmost value appearing in the first worksheet, in cell A1. | ||
+ | |||
+ | Note: The syntax for both the "Start Location" and "Query String Location" fields is ''worksheet'';''column'';''row'' | ||
+ | |||
+ | |||
{{ListViewFooter}} | {{ListViewFooter}} | ||
* [[Using an Excel Template for List View Export Results]] | * [[Using an Excel Template for List View Export Results]] |
Revision as of 14:05, 23 April 2013
Click here to watch a video on creating and editing List Views.
When exporting to Excel has been enabled for your list view, you can also tell the system where in the resultant Excel file to position your results.
- Go to the list view configuration page.
- Click into the list view for which you wish to enable exporting.
- Click on the "Export" tab.
- In the "Start Location" and "Query String Location" fields, enter the numeric value corresponding to the worksheet, column and row your list view results should be exported to.
- 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 your list view is not filtered, the Query String will be blank.
- The default setting is 0;0;0 for both fields. This means that your list view results will be exported, with the topmost, rightmost value appearing in the first worksheet, in cell A1.
Note: The syntax for both the "Start Location" and "Query String Location" fields is worksheet;column;row
See Also
- List View Overview
- Accessing the List View Configuration Page
- Configuring List Views
- Setting the Sort Order on a List View
- Exporting List View Results to Microsoft Excel
- Exporting List View Results to Microsoft Word
- Download files from List View
- Preparing Existing Word Template for List View Export
- Quick Edit
- Historic List View
- Configuring Interactive List View Charts
- Using an Excel Template for List View Export Results