excel - How to write the VB command sheets("sheet1").select in "TCL" -

how write vb command sheets("sheetname").select in "tcl"

i'm trying open worksheet of wish(variable) in excel saved in worksheet. vb command sheets("sheetname").select. need command or program in tcl.

normally once hold of sheet handle, can call function in format:

$sheethandle <functionname> 

normally, use tcom library similar things. try following

package require tcom  set _happ [::tcom::ref createobject excel.application] $_happ visible 1 $_happ displayalerts false set _hwb [[$_happ workbooks] open myworkbook.xlsx] set _hsheets [$_hwb worksheets] set _hsheet [$_hsheets item sheetname] $_hsheet select