We know that in every pivot table we have the option to download the excel file of that pivot table in a single click using the download button.
Now what i need to do is to get this report and attach this report with the mail and send it to the employee every day.
I found the way to attach the document to the mail and send it automatically. But am unable to find a way to download the excel from the pivote table through code.
Is anyone having the solution please help me.