Export setting: ExcelSheetName: Select Excel Sheet by Name | Automation

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>