Machsupport Forum

Mach Discussion => General Mach Discussion => Topic started by: woodeye on October 06, 2008, 10:16:12 PM

Title: reading excel files in Mach 3
Post by: woodeye on October 06, 2008, 10:16:12 PM

I have several excel files, one with  x y pairs with several thousand points for linear interpolation and another in polar coordinates in degrees and y axis.  How do I import this into the g code editor? I quess what I am asking is how to import excel files into Mach 3 or how can I convert these files to g code that can be used by Mach 3?

Title: Re: reading excel files in Mach 3
Post by: sshneider on October 06, 2008, 10:45:20 PM

Hi,

How about saving your file in a DELIMTED text format (.txt).  Use something like a , (comma) as the delimiter.  Then open the text document in wordpad or Word and do a "Find a Replace" .  Search for the , and replace it with a space.

HTH,
Sid

Title: Re: reading excel files in Mach 3
Post by: Vogavt on October 09, 2008, 02:14:46 PM

Post a little bit your code and I'll see if I could write a macro for Excel to do the conversion.  A portion of each type would be needed.