Scriptsheets.com

Excel

Scriptsheets are normal Excel worksheets where Excel formulas calculate X and Y coördinates and AutoCAD commands are entered as plain text.

Drawing Setup Sample

Download: Drawingsetup.zip (33 kB)

This sample scriptsheet template automates the insertion of a drawing border and title block. The sheet makes use of named cell-ranges to store data and spreadsheet functions to look it up again.

This is an excelent sheet to study the basics of programming using the Scriptsheets Add-In and it also get you started drawing in AutoCAD aswell.

Survey data sample

Download: Survey.zip (21 kB)

This sample scriptsheet holds a named cell range which could hold various rows of XYZ coordinates.  For each row in the range a point command is written to the scriptfile. Standard worksheets functions are used to get the verying number of rows and to lookup the XYZ coordinates.

This sheet is interesting because it shows how to use a FOR/NEXT loop to pharse the rows in a named cell range.