title: Reading data from sql server into excel sheet via Web Service
body: <p>consider you have an existing excel worksheet, which needs to load data from sqlserver. The data is normalized, so reading from a table is not an option. Btw, it's Excel 2010.</p>
  
  <p>I tried to provide the data via <b>stored procedure</b>, but since I have to do some <b>data transformation</b>, SPs are not an option.</p>
  
  <p>The next idea is to provide the data via <b>web service</b>. I read this <a href="http://msdn.microsoft.com/en-us/library/office/dd819156%28v=office.12%29.aspx" rel="nofollow">article</a> but I don't like the result, because the content of the worksheet is written in the .Net code. The solution I'd prefer would be some kind of <b>data provider</b>, which can be used directly in the excel sheet, similar to reading data directly from a table.</p>
  
  <p>Is there a way to achieve that?</p>
  
  <p><b>Edit</b><br />
  Because of the first comments and answers. Consider as data transformation e.g. a conversion from ticks (<code>long</code>) to <code>DateTime</code>. I've to do it in .net, because the result depends on the target time zone.</p>