Solved

call web services from excel 2007

Posted on 2010-08-23
2
1,573 Views
Last Modified: 2013-11-10
I have this store procedure
alter PROCEDURE padron.BuscarPorNumeroDocumento
@numdle nchar(16)
as
select PDR.NUMDLE, PDR.APEPAT, PDR.APEMAT, PDR.NOMBRE
from   padron.padron_20091121 PDR
      INNER JOIN padron.ubigeo_20091121 UBI
      ON PDR.coddep=UBI.coddep
            and PDR.codpro=UBI.codpro
                            and PDR.coddis=UBI.coddis
where PDR.NUMDLE = @numdle

I want to consume it from an excel sheet, that's why I created a project such as Excel 2007 Workbook, I can not find much information, what I could do is:
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/fd918ad1-716d-4f9e-a1e8-3ac606e7f4d9
1. Create a new VSTO2005 Excel Workbook project
2. Add a web service reference to the project pointing to the web service that returns the dataset.
3. Using the Data Sources window, add the resultant dataset to your sheet as a data source.
4. From the data sources window, drag and drop the table in the dataset onto the worksheet as a ListObject.

I did all the steps.
TexBox and I have the button, my question is: what should be the code for the button to
1. capture the value q is entered textbox
2. with that value to call the web service
3. display the results in excel

I am using  Visual Studio 2008 nd Office 2007
buttonCODE.jpg
excelo2.jpg
excel01.jpg
0
Comment
Question by:enrique_aeo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 

Author Comment

by:enrique_aeo
ID: 33512065
sr experts help me in this problem, need more information?
0
 
LVL 19

Accepted Solution

by:
Amandeep Singh Bhullar earned 500 total points
ID: 33518635
Check the links

http://msdn.microsoft.com/en-us/library/dd819156%28office.12%29.aspx
http://stackoverflow.com/questions/474936/call-web-service-in-excel

Hope the links will help you solve the issue of excel connectivity with wen service
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

While working on Silverlight and WCF application, I faced one issue where fault exception occurred at WCF operation contract is not getting propagated to Silverlight client. So after searching net I came to know that it was behavior by default for s…
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question