Microsoft Excel File Format for Door Files

The Door function can create multiple copies of doors based on dimensions and quantities entered into a Microsoft Excel® file. Each row in the spreadsheet represents a door description, including style, size, quantity, and details such as horizontal or vertical mullions. Door requires the information to be organized in the spreadsheet in the following order. See the file Door Demo.xls in the ..\<Shared Data Folder>\ROUTER\Template folder for an example.

NOTE

To create multiple door copies from an .xls file, Microsoft Excel must be installed on the Mastercam workstation.

Column Heading Value
A Width Width dimension
B Length Height dimension
C Qty Number of doors to create using the parameters in that row.
D Door style Enter one of the following door styles:
  • Roman
  • L. Roman
  • R. Roman
  • Cathedral
  • L. Cathedral
  • R. Cathedral
  • Arch Notched
  • Rectangular
E Mirror arch Enter 1 for a mirrored arch or 0 (zero) for no mirrored arch.
F Outside Radius Enter an arc radius to create rounded corners on the door. Enter 0 (zero) for square corners.
G Lf. Stile Width Enter the width of the left vertical piece of the door frame.
H Rt. Stile Width Enter the width of the right vertical piece of the door frame.
I Bot. Rail Width Enter the width of the lower horizontal piece of the door frame.
J Top Rail Width Enter the width of the upper horizontal piece of the door frame.
K Arch Height Enter the overall height of the arch for applicable door styles. Enter 0 for doorstyles that do not have an arch.
L Cathedral Radius For Cathedral styles only, enter the arc radius for the upper arch. Enter 0 (zero) in this column for other door styles..
M Vert. Mull. Width Enter the width of the vertical mullions. Enter 0 for no vertical mullions.
N Hor. Mull. Width Enter the width of the horizontal mullions. Enter 0 for no horizontal mullions.
P No# Enter the quantity of horizontal mullions. Enter 0 for no mullions.

The door parameters in the Microsoft Excel spreadsheet override the parameters in the Door dialog box.

Learn more