Tag: ExcelTemplate
The ExcelTemplate function automates the action of exporting Excel templates using the format of an existing file.
<SetParam target="ExportToFile" field="ExcelTemplate" value="D:\Automation-export\mugre.xls"/>
XML

NOTES | If used with any format other than Excel, the ExcelTemplate won't cause an error but it will not initiate. |
---|
Example Script
This can be done via the ExcelTemplate field/value:
<Export Type="FlagsAndRoles">
<SetParam target="ExportToFile" field="FilePath" value="D:\Automation-export\exportedACL-ArtBug.xls"/>
<SetParam target="ExportToFile" field="ExportType" value="Excel19972003"/>
<SetParam target="ExportToFile" field="ExcelTemplate" value="D:\Automation-export\mugre.xls"/>
<SetParam target="ExportToFile" field="OpenFileOnceGenerated" value="true"/>
</Export>
XML
<Export target="GlobalACLProperties">
<SetParam target="ExportToFile" field="FilePath" value="D:\Automation-export\exported-ArtBug2.xls"/>
<SetParam target="ExportToFile" field="ExportType" value="Excel19972003"/>
<SetParam target="ExportToFile" field="ExcelTemplate" value="D:\Automation-export\mugre.xls"/>
<SetParam target="ExportToFile" field="OpenFileOnceGenerated" value="true"/>
</Export>
XML