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



NOTESIf 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