Excell to *.tbl 1

[mehit]

Any one knows a way to insert the data by converting excel to *.tbl.

 

[Hora]

ProTable has extension .ptd and can be opened independent of ProE with the program called protab. You can find thi utility in your ProE load point\bin

Export your Excell table in ASCII format and add the header as in my example. The separator between columns must be "SPACE".

!# Pro/TABLE
!# Pro/TABLE TM 2001 (c) 1988-2001 by Parametric Technology Corporation All Rights Reserved.
1 4 5 6
2 4 5 6
3 4 5 6
4 4 5 6
5 4 5 6

-Hora

 

[mehit]

Thanks.

I would like to know how to covert the data from excell to *.tbl.(the drawing table file.

 

[Guest0527211403]

A Pro/Table file is not the same as a Drawing Table (*.tbl) file.

The *.tbl contains information about column and row size as well as repeat region information (filters, sort order, etc).

AFAIK there is no way to export an excel spreadsheet to a table in this format. The only thing I can suggest is to show the worksheet using Insert-->Object-->MS Excel Worksheet. There is an option to bring it in from the file as well. You can resize the "table" in Pro/E by double clicking it and resizing it when the excel windows are active.

 

[robertib]

The following is a text excerpt fro the .tbl file (I opened it in Notepad) - as you will see, it doesn't have a useable format.

ãà
type €€à
draw_type à draft_ptr ãà draft_setup_ptr ãà
grid_displayed à grid âà
grid_type àorigin øð à grid_params(cart_params) âàx_spacing ày_spacing àangle ñà
last_ent_id òöà tol_default_ptr ãà
type
àvalue ø š
(6âëC-#äøµˆãhñ#°Æ÷ µíŽàang_value ø)É™)©™æà
lin_digits øöçà
ang_digits ø çà
standard à iso_tol_tbls_ptr áà setup_ptr òãà txt_hgt_ptr ãà
txt_hgt_units àdim_txt_hgt ànote_txt_hgt àtol_txt_hgt_factor )ã3àfrm_txt_hgt / àslant_txt_ang àtol_txt_width_factor )ã3àtxt_width_factor )ë3àtxt_thickness )Öfà len_gap_ptr ñãàarrow_length / àarrow_width *ø à
arrow_style àdim_txt_gap )ó3àwit_line_gap àwit_line_delta *ø àleader_elbow / àdim_lead_len / àcline_offset àsline_offset àcut_line_seg /$ àdot_diameter àatt_sym_width àatt_sym_height à dim_style_ptr ñãà
txt_orient à
orddim_txt_orient à
decimal_marker à
dual_dim à
dual_sec_units
à

 

[Hora]

robert,

notpad is not good to open a tbl file wordpar insted gives you this:

#UGC:2 DRAW_TABLE 1154 500 -1 1 1 15 2300 2000230 00000289 \
#- VERS 0 0 \
#- HOST \
#- LINK \
#- DBID \
#- REVS 0, \
#- RELL 0, \
#- UOBJ_ID 0 0 0 \
#- MACH \
#-END_OF_UGC_HEADER
#Pro/ENGINEER TM Version J-01-09 (c) 1988-2000 by Parametric Technology Corporation All Rights Reserved. 2000230
@Toc 1 0
0 1 ->
@entry 2 10
1 2 [128]
2 2 Dwg_Drawing 2b1b 27ae 0 1154 9 -1 73ea 0a61#####################################
2 2 IndentTag 52c9 36f 0 1154 11 -1 b833 d0e3#######################################


and so on

-Hora

 

[robertib]

Sorry, should have noted that this was about 1/3rd down the page - it was readable up to there.