Export to Excel

Exporting content from InfoQube to Excel can be done in 3 different ways:
 

1. Export to Excel

  1. Open the grid which contains the information to export
  2. All shown grid columns will be exported. Show / hide columns to get the desired list
  3. File > Export > Microsoft Excel
  4. An GridName.XLS file will be created in the same folder as the IQBase
Note:
  • Only items that belong to the grid will be exported.
  • The items that belong are those that meet the grid source / filter
  • To view that list, turn off Grid Column Filters, Context Parents and select the Flat List view
     

2. Copy / Paste to Excel

  1. Open the grid which contains the information to export
  2. Select items / sub-items and the desired columns
  3. Edit > Copy. Select 3-Selected grid rows and columns
  4. Open Excel and Paste
Note:
  • All selected items will be copied
  • Item hierarchy will be collapsed (i.e. flat list of items)
     

3. Live Links to Excel

Other application can view live IQ data, including Excel. Details here