×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excell to *.tbl

Excell to *.tbl

Excell to *.tbl

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

RE: Excell to *.tbl

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

RE: Excell to *.tbl

(OP)
Thanks.

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

RE: Excell to *.tbl

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.

RE: Excell to *.tbl

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 à

RE: Excell to *.tbl

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

RE: Excell to *.tbl

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources