Contents - Index - Previous - Next

M2Assistant and Excel

You may also send the contents of any table directly to an Excel spreadsheet just by clicking the Excel button. 

Use the Excel tab of the Preferences form to specify how you prefer to send the table contents to Excel. You may create an Excel template to create pre-defined reports for your EMME/2 data, or define up to five (5) different options for how you prefer to create an Excel file. 

For each option, you may choose to:
  • Specify a workbook name or use the default name that is based on the type of layer,
  • Specify a worksheet name, or use the scenario number as the worksheet name,
  • Define the first cell of the worksheet where the table contents are to be copied,
  • Include or omit the table column headings, and
  • Auto-fit the columns to the contents of each column.
     
    Note that you do not have to have Excel installed on your computer to create the Excel file using one of the five option settings.



    In order to use the Excel template feature, Excel must be installed on your computer. To specify whether Excel is installed, click the Excel tool button (or choose the File->Excel menu option) and set the checkbox indicating whether Excel is installed.