i have a store procedure where it has 13 different columns retrieved from 20 different tables i need to get user a link on single click to export data to Excel , and also if possible matched data should be bold in the excel
Discussion posts and replies are publicly visible
You could create a CSV file. But then, no text formatting.
there is one way that is a!exportdatastoreentitytoexcel() but there is no datastore enetity
The example code created by this template should get you started.
i never created a Web Api can you please help me how i can do it calling the store proc to download excel
Where are you stuck? The example code explains clearly how to transform data into CSV format.