Export setting: ExcelSheetName: Select Excel Sheet by Name

Tag: ExcelSheetName

Use the name to create or select the sheet in the Excel file the export is targeting.

XML

<SetParam field="ExcelSheetName" value="MySheetName"/>

Example Script

XML

<Export>
	<SetParam field="FilePath" value="myPath.xlsx"/>
	<SetParam field="SelectedRowsOnly" value="false"/>
	<SetParam field="ExportType" value="Excel"/>
	<SetParam field="Mode" value="AppendRows"/>
	<SetParam field="OpenFileOnceGenerated" value="True"/>
	<SetParam field="ExcelSheetName" value="MySheetName"/>
</Export>