You are here: Excel > Excel Code Writer (DLXFIND) > Export Codes to Excel

Export Codes to Excel

Export codes to Excel by using the DLX Excel add-in.

  1. Open Excel
  2. Click the Excel Mode icon or click the drop-down arrow and select Excel Code Writer (DLXFIND)
  3. Browse through the menus until you reach the page with the series
  4. (Optional) By default, your codes will be written across in a row. To switch to columns, do one of the following:
    • Click on from the excel mode menu bar to put codes in rows (default) - lets you pull in data in columns
    • Click on from the excel mode menu bar to put codes in columns - lets you pull in data in rows
    • To insert an empty cell before inserting the codes, click on

  5. (Optional) To apply a function to the series, click on the drop-down arrow on the top right and select the function you want to apply
  6. Click the series from the data directory to import the code into Excel
  7. To import consecutive codes, highlight consecutive series by holding down the mouse button over the first series and letting go of the mouse button in the last series.

  8. Build the range using the DLX Excel Add-In
  9. Perform a retrieval using the DLX Excel Add-In to retrieve the data

To exit Excel Mode either click Excel Mode again or click the close button in the right hand corner of the Haver Excel interface.