Difference between revisions of "Positioning Exported List View Results in your Excel Spreadsheet"

Revision as of 13:55, 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 default setting is 0;0;0 for both fields. This means that your list view results will be exported to

@@ Line 4: / Line 4: @@
 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 where in the resultant Excel file to position your results.
-{{ExportListViewPage}}
+<!--{{ExportListViewPage}}
+-->
 # 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.