Sample scriptsheets

It's my wish to see this page become the most intresting one of the whole website!
Containing lots of articles with acompaning sample files, freely contributed by -and shared among- you or other users...

To try these sample you first need to install the Schriptsheets Add-in.

Drawing Setup Sample

Download: Drawingsetup.zip  (22 KB)

This sample scriptsheet template automates the insertion of a drawing border and title block.
It's an excelent sheet to study the basics of programming using the Scriptsheets Add-In and it also get you started drawing in AutoCAD aswell.

1. The sheet makes use of named cell-ranges to store data and spreadsheet functions to look it up again.
   The picture below shows the cell range with page sizes.
   
   

Survey data sample

Download: Survey.zip  (12 KB)

This sample scriptsheet holds a named cell range which could hold verying rows of XYZ coordinates.
This sheet is intresting because it shows how to use a FOR/NEXT loop to pharse the rows in a named cell range.
For each row in the range a point command is writen to the scriptfile. Standard worksheets functions are used to get the verying number of rows and to lookup the XYZ coordinates.