Microsoft Excel Options Dialog Box (AutoCAD Mechanical Toolset)

Use this dialog box to specify where on the worksheet to find parts lists and specify other extraction options for all attached spreadsheets.

Worksheet

Specifies the name of the worksheet that contains the parts list.

Starting cell

Specifies the top left cell of the header row. If there is no header row, specifies the leftmost cell of the first data row.

Ignore empty rows

Allows an attached spreadsheet containing a combination of populated and empty rows to be imported. For example, if you select the check box and the set the value of the empty rows to 2, the import process will stop only after the third empty row is detected. The check box is not selected by default.

 

Empty rows to ignore

Defines the maximum number of empty rows that can be detected during the import process without stopping the import process. When the Ignore empty rows check box is not selected, you cannot define the value. The default value is 1. The maximum number of empty rows is 10.