Reading Excel.xls format using tcl code

LOHIA
LOHIA Altair Community Member
edited October 2020 in Community Q&A

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

Tagged:

Answers

  • Q.Nguyen-Dai
    Q.Nguyen-Dai Altair Community Member
    edited May 2019
    Altair Forum User said:

    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
    llyle_20499 New Altair Community Member
    edited May 2019

    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

     

Categories