generate xl reports through asp.net

[hari krishna]

hi,
I have a web control lybrary project. i have some classes. calling that
component though asp.net web form. i am using visual basic for coding.
my requirement is to generate xl reports without installig XL on that web
server machine.
i will fetch data from stored procedures and that data to be sent to each
cells in to XL sheet without opening the XL (also there will be no
installation of XL).
kindly help me how to do that. pls mail the code if possible to
vh***********@hotmail.com.

rgds,
hari.

[Sijin Joseph]

That is not possible. The best you can do is create csv files, that open
in excel by default.

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph
hari krishna wrote:

hi,
I have a web control lybrary project. i have some classes. calling that
component though asp.net web form. i am using visual basic for coding.
my requirement is to generate xl reports without installig XL on that web
server machine.
i will fetch data from stored procedures and that data to be sent to each
cells in to XL sheet without opening the XL (also there will be no
installation of XL).
kindly help me how to do that. pls mail the code if possible to
vh***********@hotmail.com.

rgds,
hari.

[hari krishna]

hi Joseph,
thanks for the reply.
But i don't know how to create CSV files through ASP.Net. kindly help me.
if u have any reference code pls send me. vh***********@hotmail.com

rgds,
hari.

"Sijin Joseph" wrote:

That is not possible. The best you can do is create csv files, that open
in excel by default.

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph
hari krishna wrote:

hi,
I have a web control lybrary project. i have some classes. calling that
component though asp.net web form. i am using visual basic for coding.
my requirement is to generate xl reports without installig XL on that web
server machine.
i will fetch data from stored procedures and that data to be sent to each
cells in to XL sheet without opening the XL (also there will be no
installation of XL).
kindly help me how to do that. pls mail the code if possible to
vh***********@hotmail.com.

rgds,
hari.