How to Create an Excel Report Based On a View in SpotlightXL?
- 1 Minute to read
- Print
- DarkLight
- PDF
How to Create an Excel Report Based On a View in SpotlightXL?
- 1 Minute to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
- In SpotlightXL, navigate to Analyze > Data.
- Select a view from the folder structure. Notice that the tab displayed is called Analyze.
.png)
- Under the Data subtask, select Design With > Excel Report to convert the view into an Excel Report. This action creates a new worksheet named after the view. The menu will update to show Excel Report options, with all data items displaying #REFRESH and cell contents containing SpotlightMetadata or SpotlightData formulas.
.png)
.png)
- Format and lay out your Excel Report.
.png)
.png)
.png)
Note:
If your view uses Display Label, the resulting Excel Report does not display the label initially after conversion. After you click Refresh, the labels appear.
Was this article helpful?