🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Reading Excel.xls format using tcl code

User: "LOHIA"
LOHIA
Altair Community Member
Updated by 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
Sort by:
1 - 2 of 21
    User: "QuyNguyenDai"
    QuyNguyenDai
    Altair Community Member
    Updated by 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?'

    User: "llyle_20499"
    llyle_20499
    New Altair Community Member
    Updated by 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

     

Quick Links