Have you had a look at this article
You can make any filters applied to the dashboard also effect the hidden worksheet, and then click on the download CSV button to download the data
Hope this helps
the blog you provided is about exporting full data in .CSV formate. I need filtered Data.
But as the sheet is part of the dashboard, any quick filters and action filters can also be applied to it, limiting the data that is exported