You can use this action to open or create an Excel Sheet in a file that you’ve opened or created.
Description of the parameters:
ID Of Excel Window: The Id of the Excel file that you’ve opened or created in which want to create or open a sheet.
Sheet Name: By selecting this option, you can open or create a Sheet with its name. You can insert the name of the sheet in field that’s below this option or use the % sign to insert the variables you want.
Sheet Index: If instead of using the Sheet Name, you want to open it with its position, you can use this parameter. You can insert a number or use the % sign and insert a numeric variable.
Create Sheet If Does Not Exist: By selecting this option, if the Macro can not find the sheet, it will create one with the specified name.