Excell to *.tbl
Excell to *.tbl
(OP)
Any one knows a way to insert the data by converting excel to *.tbl.
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
|
RE: Excell to *.tbl
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
RE: Excell to *.tbl
I would like to know how to covert the data from excell to *.tbl.(the drawing table file.
RE: Excell to *.tbl
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.
RE: Excell to *.tbl
ãà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 à
RE: Excell to *.tbl
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
RE: Excell to *.tbl