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 List in one of the following ways

   • Actionbar:Role Engineering Task Reinforcement Task area Bar reinforcement

   • Menu bar: Create Engineering Bar Reinforcement

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

   Bar Reinforcement

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 selection rectangle, hold down the left mouse button and open a selection rectangle around the elements you want to select.
   • Some tools allow you to select all elements in the current document by clicking All in the input options or pressing CTRL+A.

   To get detailed information on all selection options provided by Allplan, see Selecting elements, overview.

   When selecting elements, you can use filters, which allow you to filter by element type or property. For more information, see Using filters.

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.