[原创]：EXCEL to AutoCAD 的问题

袖子

各位老大，请问附件EXCEL中的一组数据，如何转换并用AutoCAD R14中的ASCPOINT调入！

谢谢！

---------------------------------------------------------------------------------------------------------------
我把下面这组数据存为.prn格式后，用ascpoint调入，为什么又出现错误？
晓东的老鸟帮帮忙了！
-----------------------------------------------------------------------------------------------------------------------------
读取坐标值(Reading coordinate data)...
Unknown variable name.  Type SETVAR ? for a list of variables.Unknown command
"0,348.16".  Press F1 for help.

Unknown variable name.  Type SETVAR ? for a list of variables.Unknown command
"35.1684935570014,345.16".  Press F1 for help.

Unknown variable name.  Type SETVAR ? for a list of variables.Unknown command
"49.1017810955863,342.16".  Press F1 for help.
----------------------------------------------------------------------------------------------------------------------------

0,348.16
35.1684935570014,345.16
49.1017810955863,342.16
59.1582435669753,339.16
67.1531240884047,336.16
73.8090556077014,333.16
79.502324713311,330.16
84.4582215436785,327.16
88.8239153752731,324.16
92.701477443232,321.16
96.1648597972645,318.16
99.269442669459,315.16
102.057775217757,312.16
104.563211983736,309.16
106.812314150626,306.16
108.826489531112,303.16
110.623143907604,300.16
112.216507610124,297.16
113.618239530822,294.16
114.837874279836,291.16
115.88315578432,288.16
116.760286407289,285.16
117.474111327959,282.16
118.028251580099,279.16
118.42519464549,276.16
118.666348124299,273.16
118.752059265237,270.16
118.681600669754,267.16
118.453119962734,264.16
118.063548299146,261.16
117.508458799886,258.16
116.781860708485,255.16
115.875907139903,252.16
114.780481861476,249.16
113.482610162231,246.16
111.965603954423,243.16
110.207788568209,240.16
108.18053991846,237.16
105.845120738188,234.16
103.14728009257,231.16
100.007314230366,228.16
96.2998009285331,225.16
91.8056795161962,222.16
86.0684799434593,219.16
77.6940740220707,216.16
64.6753641793512,213.16
51.3415720268737,210.16
38.3122879289177,207.16
25.0340401433107,204.16
11.9482635556513,201.16
-1.3390294376316,198.16
-14.5086314169086,195.16
-27.8461058214468,192.16
-41.1185043924825,189.16
-54.5355210759947,186.16
-67.9260684506996,183.16
-81.4458400884655,180.16
-94.9685751266068,177.16
-108.611106372807,174.16
-122.279914384706,171.16
-136.063647723193,168.16
-149.892873254728,165.16
-163.835679279181,162.16
-177.840483112955,159.16
-191.96030967991,156.16
-206.156915586689,153.16
-220.472259627456,150.16
-234.878165427717,147.16
-249.408457696232,144.16
-264.042650640719,141.16
-278.808606861536,138.16
-293.691807160412,135.16
-308.715780695015,132.16
-323.870730433378,129.16
-339.17709312266,126.16
-354.628906537158,123.16
-370.244481724832,120.16
-386.02107495051,117.16
-401.975648028866,114.16
-418.108271315947,111.16
-434.435207915132,108.16
-450.959111158532,105.16
-467.696121657281,102.16
-484.651395795706,99.16
-501.841498337506,96.16
-519.274152546443,93.16
-536.966907455177,90.16
-554.930268153897,87.16
-573.183388500223,84.16
-591.7399462627,81.16
-610.621439180998,78.16
-629.845332807216,75.16
-649.436406129755,72.16
-669.416835769483,69.16
-689.815936833276,66.16
-710.661970700489,63.16
-731.990551147787,60.16
-753.838092638265,57.16
-776.249099490055,54.16
-799.271336135218,51.16
-822.962195253766,48.16
-847.385926883879,45.16
-872.619318757319,42.16
-898.751795317809,39.16
-925.890833796015,36.16
-954.166772919765,33.16
-983.739049617756,30.16
-1014.81016512777,27.16
-1047.63618151543,24.16
-1082.56226296198,21.16
-1120.05064971036,18.16
-1160.78179515994,15.16
-1205.7670472384,12.16
-1256.75018895504,9.16000000000003
-1316.98849004202,6.16000000000003
-1395.02422632682,3.16000000000003
-1543.33417293047,0.160000000000025

袖子

最初由 袖子 发布
[B]各位老大，请问附件EXCEL中的一组数据，如何转换并用AutoCAD R14中的ASCPOINT调入！

谢谢！

------------------------------------------------------------------------------------------------------------... [/B]

*-*a    版主那？

oygn

偶只知道把Excel里面的内容调入到CAD中，象你这种应用，偶在2006里面也实现不了，R14里估计更不行了。

袖子

最初由 oygn 发布
[B]偶只知道把Excel里面的内容调入到CAD中，象你这种应用，偶在2006里面也实现不了，R14里估计更不行了。 [/B]

不会呀！这个应用是别人用过的，而且ascpoint这个命令好像2006里面没有，只有R14里有。应该有高手会用拉。

yehenl

没有用过

oygn

如果真的象楼主所说的那样，那这个方法可真是有用，期待有高手不吝赐教。我也想学习。

袖子

版主一类的高手来过了吗？来了留个信，别老让我等者。

jsxsg

我也不会

huchfa

使用Excel行不行啊,复制----粘贴

海边的狼

真的好难，也想请教一下老鸟们

zcf108

我是低手，你这个“,ASCPOINT调入”我不懂
是画线的时候插入命令行吗？这个我知道

aichong

AutoCAD Bonus Tools ：
ASCPOINT          Reads coordinate data from file
Reads coordinate data from an ASCII file and generates either a continuous string of Lines, a Polyline, a 3DPolyline, multiple copies of a selected group of objects, or AutoCAD Point entities.

Command line: ascpoint
        ASCPOINT.LSP

File to read: Specify file name with extension of ASCII file to read.
Comma/Space delimited <Comma>: Enter S for space delimited or press ENTER for comma-delimited format.
Generate Copies/Lines/Nodes/3Dpoly/<Pline>: Select an option.

Options

Comma delimited        Reports one coordinate per line, with each component separated by a comma.
Example: 2.333,4.23,8.0
Space delimited        Reports one coordinate per line, with each component separated by one or more spaces.
Example: 2.333  4.23  8.0
Generate copies        Prompts for the objects that are to be copied.  The base point for all copies is the current UCS origin (0,0,0).  One copy of the selected objects will be created for each incoming coordinate and placed at each coordinate.  All numeric values must have at least one digit to the left and the right of the decimal point (values less than one must have a leading 0).  A leading minus sign indicates negative values.  This applies to both CDF and SDF formats.
A selected group of objects can be duplicated, creating one copy for each incoming coordinate, and using it as the absolute copy displacement from the current UCS origin (0,0,0).

Lines        Generates a continuous chain of line entities from the coordinate data.  Each pair of adjacent lines share a coordinate from the file.  It can also create a polyline or 3DPolyline from the coordinate data, where each point in the file becomes a vertices of the polyline.  If the input file contains 3D coordinates, and you specify a polyline, then the Z component is ignored and the default of 0.0 is used.
Nodes        Generates AutoCAD Point entities from data in a file.  Specify the point size and type prior to invoking ASCPOINT.

3Dpoly        Creates a polyline or 3DPolyline from the coordinate data, where each point in the file becomes a vertices of the polyline.  If the input file contains 3D coordinates, and you specify a polyline, then the Z component is ignored and the default of 0.0 is used.

spectre007

没有用过，最后这位说的是什么？