output data from the result of storedprocedure into excel format

23 May 2006 11:26 AM

Thanks

I am using asp.net(2003). I would like to output the data from the result of
storeprocedure (sql 2000 server) into excel format. (office 2003) Can I do
that?
Please show me the coding if it can.

23 May 2006 2:53 PM

Dean Hinson

Hello,

I don't ahve any code because I haven't done any ASP.Net. However, I would
think that when you place the results into a dataset or recordset, all you
have to do is create an Excel object and 'load' the data into the worksheet.
When done, use the saveas method to save the workbook where you want it.

I done things like this is VB script, so I would think it is easily done is
ASP.Net.

Hope this helps.

Show quoteHide quote

"Thanks" wrote:

> I am using asp.net(2003). I would like to output the data from the result of
> storeprocedure (sql 2000 server) into excel format. (office 2003) Can I do
> that?
> Please show me the coding if it can.

24 May 2006 6:12 AM

Thanks

Can you show me any reference web page about that?

Show quoteHide quote

"Dean Hinson" wrote:

> Hello,
>
> I don't ahve any code because I haven't done any ASP.Net. However, I would
> think that when you place the results into a dataset or recordset, all you
> have to do is create an Excel object and 'load' the data into the worksheet.
> When done, use the saveas method to save the workbook where you want it.
>
> I done things like this is VB script, so I would think it is easily done is
> ASP.Net.
>
> Hope this helps.
>
> "Thanks" wrote:
>
> > I am using asp.net(2003). I would like to output the data from the result of
> > storeprocedure (sql 2000 server) into excel format. (office 2003) Can I do
> > that?
> > Please show me the coding if it can.