Is there any way to get an excel export from a SharePoint list and email to users in SharePoint 2010?
We have a list which update weekly and I want to email all users in format of Excel
Default Functionality of export to excel for list is Awesome, but according to me the same cannot be call through any API. So I would suggest rather than Workflow, go with SharePoint Timer Job feature.
This link would help you do the same and achieve your functionality
You can also achieve the same functionality using PowerShell code to export the list to Excel file and then send email to the mail adress, and use the Windows Task Scheduler to trigger the above PowerShell code daily/weekly/monthly, please see more from posts below.