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.
button and menu
In each session where you can export data to Excel, this functionality is available:
- This 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:
- : Directly exports the selected data using default settings.
- : Starts a session where you can specify settings for the export.
- : Starts a session where you can select the fields to be exported.
- : Starts a session where you can specify general export and import settings for all sessions.
- : 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 button in the toolbar, click this down arrow.
- If no down arrow is displayed, select .
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.