?
Solved

call web services from excel 2007

Posted on 2010-08-23
2
Medium Priority
?
1,584 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 2000 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

Here I am going to explain creating proxies at runtime for WCF Service. So basically we use to generate proxies using Add Service Reference and then giving the Url of the WCF service then generate proxy files at client side. Ok, what if something ge…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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 this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

764 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