Step 1: Name your worksheet which you want to export alphabetically first example name it as abc
Step 2: Download image from web and use the web object place the image in dashboard
Step 3: Publish the dashboard with icon after publishing get the dashboard URL
Step 3: right click on image and set the url with https://servername/views/reportname/dashbaordname.csv
When user clicks on the excel image icon automatically sheet data will be downloaded
Hope this , if helps mark as helpful or correct
Naveen thanks for your reply but unfortunately this is already tried. I too mentioned it in my post.
I dont want the overhead of creating worksheet. I just need a short way to do same thing what you achieve by clicking blue link (as per my screen shot).
Thanks for your reply but this dosent help ..