Populate date into excel from DataSet/DataTable

[Dhans]

Hi there,
We are developing a WPF windows application in .NET 3.5 & VS 2008

We have the following requirement
1. An excel template will be available in server side, in which the
webservice is being hosted.
2. We need to call a webservice to get the data from database and populate
the data in the predefined excel template available in the step1.
3. Then download the data populated excel to the client side.

Is there any elegant way of doing this in server side, since its webservice
multiple client might call this consume this to get this done. Please advice.

Thanks,
Dhans

 

[james]

if you had a web server (ASP.NET) you can return the data as XML file,
and with fancier XML/XLST coding you could use a template.

Another is to have the app create an excel object using the template,
get the web service data into data set/table, paste the data set into
the predefined range, assuming you've designed the template so that
any size data could be accommodated.