Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Populate date into excel from DataSet/DataTable


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.



On Nov 18, 12:37*pm, Dhans wrote:
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function to lookup date on tab in excel and populate date on calen MGC Excel Worksheet Functions 0 February 4th 10 04:48 AM
How to Transfer an Excel Range to an ADO.Net DataSet or DataTable in VB.Net? TCook Excel Programming 4 November 3rd 06 12:28 PM
assign dataset to matching dataset Michael Dirksen Excel Programming 0 June 16th 06 04:34 PM
Converting A Quarterly Dataset to Weekly Dataset Dan Thompson Excel Programming 5 November 25th 05 09:27 PM
Excel into DataTable using OleDbDataAdapter Matthew_H Excel Programming 1 March 4th 05 08:25 AM


All times are GMT +1. The time now is 10:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"