LINEAR Solutions 26 for AutoCAD

Importing Buildings from Excel Room Data Sheets

Shows step by step how to transfer a building from a room data sheet that is available in Excel format into LINEAR Building.

Before you begin

You have a room data sheet in Excel format and want to import the room data into LINEAR Building.

Requirements

The Excel file is not open in any other program.

Navigate to

Toolbar

Procedure

  1. Click on Import Building from Excel Room Data Sheet in the Main Menu .

    The Select Template dialog opens.

  2. Select the desired template and click OK.
    The dialog Import Excel Room Data Sheet opens.
  3. Click on and select the desired Excel file.
    Dialog "Import Excel Room Data Sheet” in LINEAR Building
  4. For the selected Excel room data sheet, configure the settings for Worksheet, ID Column, Row Header, and Data from Row.
  5. In the Room Parameter column, click on in the respective rows to assign the LINEAR room parameters corresponding to the columns of the room data sheet.
    Important: For a successful data import, at least storey and room names are required as room parameters.
  6. If you need new room parameters for assigning the columns of the Excel room data sheet, click on in the respective rows, select New Parameter, specify the name and Unit () in the dialog that appears, and click OK.
    The new parameters are created, assigned, and saved in the project during import. After import, the new room parameters are available in the Room Data Sheet module.
  7. Click on Import after the assignment is complete.

Results

A message confirming the successful import is displayed. The data from the Excel room data sheet has been transferred to the assigned room parameters and a building structure has been created based on the data. All transferred data is available in the corresponding property sets of the Room Data Sheet module.