tcl to excel

Altair Forum User

Hi all,

Can we write tcl variables to a excel file.

 

Thanks ,

Mahes

Altair Forum User

Hi Mahes,

Can you please elaborate on this, what variables are you trying to export as csv?

Altair Forum User

Hi George,

for example I have a comp id 1

I wanna get the info about the component and write to a excel file.

 

 

Thanks,

Mahes

tinh

Hi

Switch model browser to 'component view' mode, right click on browser and select 'export' to csv file

 

Or, in utility tab, click 'component table' and select File > export to csv file

Altair Forum User

Hi tinh

I need to do in macro...the above thing is just a example.

 

 

 

Thanks,

Mahes

tinh

Ok it is like this

set fpt [open c:/sample.csv w]

fconfigure $fpt -encoding uft-8

puts $fpt 'comp id,comp name,thickness'

foreach compid {1 2 3 4 5} {

puts $fpt '$compid,[hm_getentityvalue comps $compid name 1 -byid],[hm_getthickness comps $compid]'

}

close $fpt

 

You should use csv package with commands ::csv::join and ::csv::split to handle strings with special characters

 

Altair Forum User

Altair Forum User said:

Ok it is like this

set fpt [open c:/sample.csv w]

fconfigure $fpt -encoding uft-8

puts $fpt 'comp id,comp name,thickness'

foreach compid {1 2 3 4 5} {

puts $fpt '$compid,[hm_getentityvalue comps $compid name 1 -byid],[hm_getthickness comps $compid]'

}

close $fpt

 

You should use csv package with commands ::csv::join and ::csv::split to handle strings with special characters

 

Thanks tinh.

I will try thiz champ

Altair Forum User

Hi tinh,

@tinh

for using fconfigure , uft  is there any package I need to import

 

 

 

Thanks,

mahes

tinh

No, you don't.

it is for case you have unicode characters in data, example compnáme

Altair Forum User

Thanks tinh..