Reading Excel.xls format using tcl code

LOHIA

I am trying to read the excel.xls format in hypermesh, it is not showing the values in the excel

if the excel is converted into csv it can read values.

can any one tell me whether the excel.xls format can be read in hypermesh?

set excel [open 'Input_Sheet.xls' r]
set fileData [read -nonewline $excel]
close $excel

Find more posts tagged with

English

HyperMesh

Accepted answers

All comments

QuyNguyenDai

I am trying to read the excel.xls format in hypermesh, it is not showing the values in the excel

if the excel is converted into csv it can read values.

can any one tell me whether the excel.xls format can be read in hypermesh?

The real question is : 'Excel.xls format can be read by Tcl shipped with Hypermesh?'

llyle_20499

Hi Lohia,

You cannot read Microsoft Excel using direct file reading operations. Excel can be read using additional tcl packages using twapi.

you can try using CAWT which makes this process simpler.

http://www.cawt.tcl3d.org/

Do note that twapi will not work in other operation system such as Linux.

Regards,

Livil Lyle