Voith's Code - Import / Export

Hide details for ADDITIONAL: Start Excel export from a Toolbar- or Actionbar button with @Formula or LotusScript!

ADDITIONAL: Start Excel export from a Toolbar- or Actionbar button with @Formula or LotusScript!
ADDITIONAL: Start Excel export from a Toolbar- or Actionbar button with @Formula or LotusScript!

Starting from release 1.1.0.2476 (released 23OCT2012), you have a cool way of extending IEL. You can now kick off IEL by a single click on a toolbar button, or via an Actionbar button, and have IEL export the current view to Excel with it's "Export Notes View format to Excel" automatically turned on. This makes it super quick and easy to export any view. Note that this is an additional way of starting IEL, so you can off course starte IEL the normal way too, by using File -> Import or File -> Export menues.

When you have finished this guide, you will have a nice toolbar like this;

The first button launches the IEL dialog box in Export mode from your current view, so you still can choose which fields to export etc.

The second button instantly exports all documents in view to an Excel file, without bringing up the dialog box. In other words, you get what you see in Notes instantly to Excel!

The third button do the same as for the second button, but now you export the selected documents instead.

Head over here to see how the toolbar and the buttons are built