擁有大量座標點(如測量點、管線節點、結構節點)儲存在 Excel,需快速在 AutoCAD 中繪製連線或曲線。透過 VBA 讀取 Excel 資料並呼叫 AutoCAD ActiveX API,即可實現「資料驅動繪圖」,大幅縮短人工點擊時間並確保精度。
D:\cad\vba\fzcp.xls,工作表名 sj,資料結構如下:| 欄 | 內容 |
|---|---|
| A | X 座標 |
| B | Y 座標 |
| C | Z 座標 |
| F1 | 線段總數 (i) |
| F2 | X 偏移 (m) |
| F3 | Y 偏移 (n) |
| F4 | Z 偏移 (t) |
VBAIDE 或 工具 → 巨集 → Visual Basic Editor)。EXCEL.EXE)。


Option Explicit
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Sub DrawFromExcel()
'--- 開啟 Excel ---
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Open("D:\cad\vba\fzcp.xls")
xlApp.Visible = False
Set xlSheet = xlBook.Worksheets("sj")
'--- 讀取參數 ---
Dim i As Long, m As Double, n As Double, t As Double
i = xlSheet.Cells(1, 6).Value ' 線段數
m = xlSheet.Cells(2, 6).Value ' X 偏移
n = xlSheet.Cells(3, 6).Value ' Y 偏移
t = xlSheet.Cells(4, 6).Value ' Z 偏移
Dim p As Long
Dim k1 As Double, h1 As Double, k3 As Double
Dim k2 As Double, h2 As Double, h3 As Double
Dim lineObj As AcadLine
Dim startPt(0 To 2) As Double
Dim endPt(0 To 2) As Double
'--- 迴圈繪製每段線 ---
For p = 0 To i - 2
' 起點座標(第 2+p 列)
k1 = xlSheet.Cells(2 + p, 1).Value
h1 = xlSheet.Cells(2 + p, 2).Value
k3 = xlSheet.Cells(2 + p, 3).Value
' 終點座標(第 3+p 列)
k2 = xlSheet.Cells(3 + p, 1).Value
h2 = xlSheet.Cells(3 + p, 2).Value
h3 = xlSheet.Cells(3 + p, 3).Value
' 加上偏移
startPt(0) = k1 + m: startPt(1) = h1 + n: startPt(2) = k3 + t
endPt(0) = k2 + m: endPt(1) = h2 + n: endPt(2) = h3 + t
' 在模型空間建立線段
Set lineObj = ThisDrawing.ModelSpace.AddLine(startPt, endPt)
Next p
'--- 收尾 ---
xlBook.Close False
xlApp.Quit
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
MsgBox "繪圖完成!共 " & i - 1 & " 段線。"
End Sub
DrawFromExcel → 執行。
若需依座標繪製圓弧,可參考以下事件程序架構(需在表單模組中配合按鈕使用):
Private Sub CommandButton1_Click()
Dim curves(0 To 1) As AcadEntity
Dim centerPt(0 To 2) As Double
Dim radius As Double, startAng As Double, endAng As Double
' 圓心座標
centerPt(0) = <圓心X>: centerPt(1) = <圓心Y>: centerPt(2) = <圓心Z>
radius = <半徑>
startAng = <起始角度> / 180 * 3.141592653 ' 轉弧度
endAng = <結束角度> / 180 * 3.141592653
Set curves(0) = ThisDrawing.ModelSpace.AddArc(centerPt, radius, startAng, endAng)
End Sub
On Error Resume Next 並檢查 Err.Number,避免資料遺漏導致中斷。AddPolyline 一次建立多段線,或關閉螢幕重繪 ThisDrawing.RegenAcDb 後再重繪。透過 VBA 串接 Excel 與 AutoCAD,將「手動點選座標」轉為「批次讀取座標 → 自動建立幾何」,不僅提升效率,更確保幾何精度來源單一、可追蹤。掌握此技能後,可輕鬆應用於測量放樣、管線佈設、結構節點匯入等實務案例。