Create Excel Spreadsheet

Module(s): Bar Reinforcement

You can use the Create Excel Spreadsheet tool to export reinforcement data to an Excel file. The appearance of the Excel spreadsheet is based on a template file, which can be customized.

To generate a non-associative Excel spreadsheet

1. Click Create Excel Spreadsheet (How).
   

   Activate Create Excel Spreadsheet in one of the following ways

   • Menu bar: Create Engineering Bar Reinforcement

   • Palette: Tools Create area in the following module(s):

   Bar Reinforcement

   • Configuration: Engineering List/Schedules flyout
2. Click in the Input options to find elements based on advanced criteria.
3. Select the reinforcement elements by clicking them, enclosing them in a selection rectangle or fence, or using the bracket tool
   or
   Double-click with the right mouse button or click All in the Input options to select all the marks.
   

   • To select a single element, click it.
   • To select elements in a region, use the left mouse button to open a selection rectangle around the elements you want to select
   • To include all the elements in the current document, click All in the Input options or press CTRL+A. Please note that this option is not available for all tools.

   For more information on the options available for selecting elements in Allplan, see Selecting elements, overview.

   When selecting elements, you can use the Filter Assistant to apply a filter based on element types and/or properties. For more information, see Filter Assistant.

4. Select a template file, which defines the layout of the Excel spreadsheet.
5. Save the reinforcement data as an Excel-format file.

   Microsoft Excel starts and the spreadsheet created opens automatically.

Note: Please note that this requires Excel 2002 or higher.