Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1591
  • Last Modified:

call web services from excel 2007

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
enrique_aeo
Asked:
enrique_aeo
1 Solution
 
enrique_aeoAuthor Commented:
sr experts help me in this problem, need more information?
0
 
Amandeep Singh BhullarCommented:
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now