PDA

View Full Version : Converting XYZ coordinates



Tmap
08-21-2010, 11:31 PM
Hello,

I was someone could help me with this computer programming question. I have XYZ coordinates in an excel spreadsheet. I was wondering how to convert the file format into something the CNC can utilize. Hopefully into a format VCarvePro can read.

Thanks,

dana_swift
08-22-2010, 12:18 AM
There are several simple solutions, depending on your skill level with programming. The trick is to get to a DXF file, of all the file formats VCarvePro can import, XYZ data is not one of the options, DXF is at least doable. The easiest is not the most simple to explain, but here goes:

Insert a column in front of the XYZ coordinates and fill it with "M3".

Save the file as "comma delimited text". So now you have a file named "output.cdt" or some such name. Rename the extension only to "sbp", what you have created is a cut file for the bot. (Read the file in notepad to check that it came out correctly according to the SB command reference manual.

Then use the utility in the SB3 control program, under the Files menu is a converter from SB3 to DXF. Create a DXF from the SBP.

Open the DXF with VCarvePro.

Hopefully you have the result you seek-

D

dana_swift
08-22-2010, 12:32 PM
Been thinking more about this one, it would be useful to have a simple utility that converted XYZ data in Excel to objects in a DXF file.

Now you have me thinking about what would be involved with writing such a thing. I would find it hand for sure-

D

adrianm
08-22-2010, 01:19 PM
How about this http://www.ransen.com/Pointor/convert_excel_to_dxf.htm ?