Get-All-Worksheet-Names

Command Description

Get the names of all worksheets under the specified Excel

Command Prototype

arrayRet = Excel.GetSheetsName(objExcelWorkBook)

Parameter Description

Parameter	Required	Type	Default	Description
objExcelWorkBook	True	expression	objExcelWorkBook	Excel workbook object (workbook opened with "Open Excel" command (Excel.OpenExcel) or the workbook object returned by the command "Bind Excel" (Excel.BindBook))

return

arrayRet，The variable used to save the output of the command.

Demo

/********************Get all sheet names ************************ ****** 
**Incoming parameters: 
**      objExcelWorkBook--Excel workbook object (a workbook opened using the  "Open Excel" command (Excel.OpenExcel)  or a job bound using the "Bind Excel" command (Excel.BindBook) book object). 
**Exports: 
**      arrayRet--The variable to which the output of the function call is saved. 
** 
*********************************************************************/ 
  
objExcelWorkBook = Excel.OpenExcel(@res"Test.xlsx",True,"Excel","","") 
arrayRet = Excel.GetSheetsName(objExcelWorkBook) 
TracePrint "Get all worksheet names: All worksheet names of the Excel object have been obtained, as: " 
TracePrint arrayRet 
Excel.CloseExcel(objExcelWorkBook,False)