Page 1 of 1

point in excel sheet

Posted: Mon Mar 30, 2009 5:37 pm
by hborsarello
Hello,

Can someone help me?
I have a curve to trace that is defined by some (a lot) X,Y coordinate in an excel sheet, is it possible to make a script or other method to achieve my goal?

Thanks
Hugues

Posted: Mon Mar 30, 2009 6:57 pm
by andrew
Yes, this should be possible.

First you will have to convert your data into something easy to parse, for example CSV (plain text file, fields separated for example with tabs).

Then have a look at the example script "inputxy.qs" and example data "inputxy.txt" which should at least be a good starting point.

Posted: Mon Mar 30, 2009 7:28 pm
by hborsarello
Thanks,

I'm trying but have some problem, that say that cannot read the file.... the tutorial is for windows and i'm on osX, do you think thay can be the point??


Hugues

Posted: Mon Mar 30, 2009 8:39 pm
by andrew
hborsarello wrote:I'm trying but have some problem, that say that cannot read the file....
You might have to enter the full path of the file you want to read or hard-code it into the script or extend the script to display a file open dialog.
hborsarello wrote: the tutorial is for windows and i'm on osX, do you think thay can be the point??
I'm not sure I understand you correctly. What tutorial are you looking at?

QCAD generally behaves almost the same on all platforms.

Posted: Wed Apr 01, 2009 3:06 pm
by hborsarello
Great it works.......
But another question to specialists : inputxy script makes segment between each xy point, is it possible to modify it to create polyline? or is there a solution to do the transformation of a lot of segment (about 2000, difficult by hand) in a polyline?

Thanks a lot
hugues

Posted: Wed Apr 01, 2009 3:25 pm
by andrew
You can use the tool to create a polyline from segments:
http://www.ribbonsoft.com/qcad/manual_r ... r21.html#8