MS Excel integration

In LN sessions that show data directly from a table, you can export data to, and import data from, MS Excel. After starting such a session, you can select the tabs and columns you want to export. Then you can perform a quick export or an advanced export.

During the export, a .xlsx workbook is generated. To open this workbook you need one of the following:

  • Microsoft Excel 2007 or later
  • Microsoft Excel 2003 with a Microsoft Office compatibility pack

After exporting data from a session, you can edit the Excel export workbook and import the workbook back into the same session. Only cells with edit permissions are imported.

Excel button and Export and Import menu

In each session where you can export data to Excel, this functionality is available:

  • This Excel button in the session's toolbar:

    Click this button to perform an export based on the default export mechanism that is specified in your general export settings.

  • A menu with these commands:
    • Quick Export: Directly exports the selected data using default settings.
    • Advanced Export: Starts a session where you can specify settings for the export.
    • Fields to Export: Starts a session where you can select the fields to be exported.
    • Settings: Starts a session where you can specify general export and import settings for all sessions.
    • Import: Starts a session where you can specify settings for the import.

    The location of this menu depends on LN Tools parameter settings. To open this menu, perform one of these actions:

    • If a down arrow is displayed next to the Excel button in the toolbar, click this down arrow.
    • If no down arrow is displayed, select Actions > Export and Import.

General settings for the export process

Before you can start your first export, you must specify general settings for the export process. These settings apply to all sessions for which no session-specific settings are defined.

General settings for the import process

Before you can start your first import, you must specify general settings for the import process. These settings apply to all sessions for which no session-specific settings are defined.