Want to get data fetched by Stored Procedure to excel file(sheetwise)

Question

We have one stored procedure which has different input parameters and it is fetching data from multiple tables.

Also we have on excel template with multiple sheet. we want to insert data into excel sheet by creating different queries. Does anybody tried that before?

score 0 · Answer 1 · answered Jul 02 '19 at 09:59

0

There are different ways to achieve this. When you want to write a program using .Net (what I expect from your tags), I can recommend EPPlus.

answered Jul 02 '19 at 09:59

Michael Tobisch

1,034
6
15

Currently i want to make everything in sql job – SagarS Jul 02 '19 at 10:08
Maybe [this question](https://stackoverflow.com/questions/9086880/t-sql-export-to-new-excel-file) has the right answer for you... – Michael Tobisch Jul 02 '19 at 10:33

Want to get data fetched by Stored Procedure to excel file(sheetwise)

1 Answers1