I have a table object on a tab in my QLV dashboard. What I wanted to be able to do is to use a button action to perform an automated Export to Excel (Send to Excel). I can use the icon on the title bar but user complain that this is too small and potentially located off the screen real estate forcing a scroll first.
I was hoping to be able to get to the Send to Excel method of the Table Object through the action editor but did not see a way. Our enterprise does not allow Macros to be used.
Is there a way to do this?
The Export action does some of it, however it creates a CSV and not XLS file