import .xls file, points
import .xls file, points
(OP)
Hi,
How can I import an .xls file, I want to create a point cloud surface.
I have donde this with .dat files is there another way?
Thanks.
How can I import an .xls file, I want to create a point cloud surface.
I have donde this with .dat files is there another way?
Thanks.





RE: import .xls file, points
However, once the next version of NX is released there will be a function which will, for all intents and purposes, allow you to do just that.
John R. Baker, P.E.
Product 'Evangelist'
Product Design Solutions
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
http://www.siemens.com/plm
http://www.plmworld.org/museum/
To an Engineer, the glass is twice as big as it needs to be.
RE: import .xls file, points
Can anyone load this macro or journal,(program)
for importing .XLS points to NX.
It can be a great help...
Thanks.
RE: import .xls file, points
http://www.eng-tips.com/viewthread.cfm?qid=296588
RE: import .xls file, points
Remember this is just a demo. It is of course possible to use data directly.
Hope this helps.
Frank Swinkels
RE: import .xls file, points
I have tried to import this excel document, with Franks VB...
browse and I can import it... the document is an .XLSX file,
Office 2010..., what I am doing wrong. I upload the documnet.
Thanks.
RE: import .xls file, points
Frank Swinkels
RE: import .xls file, points
Sorry about the error.
Frank Swinkels
RE: import .xls file, points
I have tested it with Excel 2010, I can find the .xls file but I can't read it. Can be office version problem?
Can you send me and example of an .xls file tested by you?
I don't know what I am doing wrong...
Sorry,
Thanks all.
RE: import .xls file, points
The following .NET libraries are supported by journaling:
mscorlib.dll
System.dll
System.Windows.Forms.dll
System.Drawing.dll
To access excel workbooks System.dll has a data class.OleDb which has a method OleDbConnection.
Unfortunately this method can only open excel spreadsheets to Excel 97-2003 format.
To read later spreadsheets we need to use the Microsoft library. Specifically Microsoft.Office.Interop. With this we can read 2010 spreadsheets.
To summerize we can use journals to read spreadsheets up to Excel 97-2003 format. To read later format spreadsheets we cannot use a journal. We can build the source code as an executable (.exe or .dll) to read the later formats.
Frank Swinkels
RE: import .xls file, points
I have tested with 97-2003 format...
I upload from 2003 office. I can't run the vb...
Thanks.
RE: import .xls file, points
I have attached my simple test example. I have also included the journal. Just to make sure I have changed the file extension to .txt. Just change it back to .vb to run the journal. My simple example excel is data2.xls.
Regards
Frank Swinkels
RE: import .xls file, points
thanks for the .xls example.
I have to know ho to insert this points on NX .prt part.
Regards,
RE: import .xls file, points
Hope this helps further.
Regards
Frank Swinkels
RE: import .xls file, points
Thanks for the macro, the thing is that like the attached photo, now I can see the points with your macro, but I don't know how to accept to import these points to the NX model enviroment.
I see the cancel button, but not the accept button.
Thanks.
RE: import .xls file, points
As before I have renamed the vb file to a txt file. Just rename it back to .vb to run the journal.
Regards
Frank Swinkels
RE: import .xls file, points
Yes, I was looking for this VB.
Thanks.