8,849
edits
Changes
no edit summary
* The default setting is 0;0;0 for both fields. This means that your list view results will be exported, with the topmost, leftmost value appearing in the first worksheet, in cell A1.
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">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 be referenced with a 0, as opposed to 1.
Therefore, if you wanted either the list view results or the metadata to be placed in the
third worksheet of your Excel file, starting in cell B4, you would enter ''2;1;3''
The syntax for the first worksheet, cell A1 would be ''0;0;0''</pre>
Note: If the worksheet designated as the export location does not exist, the Excel file will not be created.<br>In other words, if a three-tabbed worksheet is selected as the [[Using an Excel Template for List View Export Results|export template]],<br> and ''4;0;0'' is selected in either the "Start Location" or "Query String Location" fields, the Excel file will not be created.