Export to Excel
Exporting content from InfoQube to Excel can be done in 3 different ways:
1. Export to Excel
- Open the grid which contains the information to export
- All shown grid columns will be exported. Show / hide columns to get the desired list
- File > Export > Microsoft Excel
- 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
- Open the grid which contains the information to export
- Select items / sub-items and the desired columns
- Edit > Copy. Select 3-Selected grid rows and columns
- 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