Quick example for twapi to get values from excel.

twapi_example.tcl

puts [package names]
package require twapi

set excel [::twapi::comobj Excel.Application]
$excel DisplayAlerts [expr 0]

set workbooks [$excel Workbooks]
$workbooks Open "C:/Users/willblatt/BlattBros/Projects/10000 Temp/XLS_Files_Chip/CHIP_ASSAY_TABLE.xlsx"

set workbook [$workbooks Item 1]
set sheets [$workbook Sheets]
set sheet [$sheets Item 1]
set cells [$sheet range a1 c3]

puts [$cells Value]

$cells -destroy
$sheet -destroy
$sheets -destroy
$workbook -destroy
$workbooks -destroy
$excel Quit
$excel -destroy