Extracting point data from ProE into Excel.

[jhengel]

Does anyone know how I can extract point data from ProE into an Excel
spreadsheet?



John Hengel

MCAD Applications Support

National Ignition Facility

Lawrence Livermore National Lab.

(925) 422-7608

[bfrandsen]

John, it can be done using one of the available APIs (Pro/TOOLKIT, J-LINK,
Web-Link and VBS from WF4).
So the choice will be based on wether you are a C, Java JavaScript or
Visual Basic programmer.
All API's are documented in the APIWizards found subfolders names after
the API in your installations Pro/ENGINEER directory.
If you will be using J-Link like me, you could either write a .csv file
using Java's IO capabilities or use the Open Source HSSF API for writing
direct to Excel.
I believe VBS could give you the most direct solution, but it will require
WF4.

Regards,
Bjarne



"John Hengel" <->
09-04-2008 16:08
Please respond to
"John Hengel" <->


To
-
cc

Subject
[proecus] - Extracting point data from ProE into Excel.






Does anyone know how I can extract point data from ProE into an Excel
spreadsheet?

John Hengel
MCAD Applications Support
National Ignition Facility
Lawrence Livermore National Lab.
(925) 422-7608

-----End Original Message-----

[gbon]

I suppose you want points data from a Proe part.

So you can export a binary stl file and the open it with excel.

You will have something like :
facet normal 2.855993e-15 -8.762533e-01 -4.818508e-01
outer loop
vertex -2.561429e+02 1.657247e+01 -4.834429e+02
vertex -2.519444e+02 -2.354579e+00 -4.490237e+02
vertex -2.527500e+02 -3.291503e+00 -4.473199e+02
endloop
endfacet
facet normal 9.238522e-01 -1.844281e-01 3.353854e-01
outer loop
vertex -2.527500e+02 2.135097e-01 -4.453925e+02
vertex -2.527500e+02 -3.291503e+00 -4.473199e+02
vertex -2.519444e+02 -2.354579e+00 -4.490237e+02
endloop
endfacet
facet normal -1.494843e-14 -8.762533e-01 -4.818508e-01

so you can sort lines for keeping all vertex (points) lines.
Then you can converts thoses lines to have 4 columns :
vertex -2.561429e+02 1.657247e+01 -4.834429e+02

first column always contain "vertex" and you can delete it
then you will have x, y and z columns.


GB

[FV]

Hi all,

John,

A poor man solution(no programming required)would be manuallypick surfacelocations or datum points with Analysis->Geometry->Point Pro/E menu selection and extract measurments from a trail file with grep or findstr depending on OS.

HIH.

Feliks.

In Reply to:

Does anyone know how I can extract point data from ProE into an Excel
spreadsheet?



John Hengel

MCAD Applications Support

National Ignition Facility

Lawrence Livermore National Lab.

(925) 422-7608

[MarcMettes]

In Reply to:

Does anyone know how I can extract point data from ProE into an Excel
spreadsheet?

Can you be a little more specific? What do you mean by "point data"?
Are you looking for XYZ position data for datum points?


Marc
--
Marc Mettes
-
Visit My CAD/PDM AutomationBlog

[MarcMettes]

In Reply to:

In Reply to:

Does anyone know how I can extract point data from ProE into an Excel
spreadsheet?

Can you be a little more specific? What do you mean by "point data"?
Are you looking for XYZ position data for datum points?

You can extract point data (i.e XYZ position data) and send it to
Excel using Pro/WebLink, no external programs or files required,
unless you want that. I can post an example if you're interested.


Marc
--
Marc Mettes
-
Visit My CAD/PDM AutomationBlog
Or, Subscribe to My CAD/PDM Automation Blog by Email

[MarcMettes]

In Reply to:

Does anyone know how I can extract point data from ProE into an Excel spreadsheet?

I have posted an example of sending Pro/ENGINEER point data to Excel using Pro/WebLink on my blog:

http://inversionconsulting.blogspot.com/2008/04/weblink-send-proe-pnt-data-to-excel.html


If it's not what you're looking for, it might be of interest to others.


Marc
--
Marc Mettes
-
Visit My CAD/PDM AutomationBlog
Or, Subscribe to My CAD/PDM Automation Blog by Email