分享自動化繪圖

由 wws 2011-02-13, 23:04

PLLINE
0,194.092657246211
5,189.26525
20,183.809
40,174.02525
50,170.6235
60,166.40175
80,158.946425547226
100,153.1365
120,147.215
140,141.43175
利用excel作pline的自動化繪圖,
=H6&","&J6

由 wws 2011-02-13, 23:07

文字標示
(COMMAND "TEXT" "J" "R" "1,0" "90" "0K+000")
(COMMAND "TEXT" "J" "R" "6,0" "90" "0K+005")
(COMMAND "TEXT" "J" "R" "21,0" "90" "0K+020")
(COMMAND "TEXT" "J" "R" "41,0" "90" "0K+040")
(COMMAND "TEXT" "J" "R" "51,0" "90" "0K+050")
(COMMAND "TEXT" "J" "R" "61,0" "90" "0K+060")
(COMMAND "TEXT" "J" "R" "81,0" "90" "0K+080")
(COMMAND "TEXT" "J" "R" "101,0" "90" "0K+100")
(COMMAND "TEXT" "J" "R" "121,0" "90" "0K+120")
交字標示利用excel來作的自動化繪圖,

快速完成交付工作之縱斷面標示文字及pline

由 wws 2011-02-13, 23:09

="(COMMAND "&$H$3&"TEXT"&$H$4&"J"&$H$4&$H$5&$H$4&H6+J6&","&$I$3&$H$4&"90"&$H$4&TEXT(S6,"0K+000")&$H$3&")"
利用一此小技巧

" 0 Y座標
中心線 " " 0.0000 X座標
主線里程 R 文字標示-原有高程 A3 (m) 1.0000

結果如下
(COMMAND "TEXT" "J" "R" "1,0" "90" "0K+000")

(COMMAND "TEXT" "J" "R" "1,0" "90" "7.764")