• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

web service in 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

This stored procedure is part of a web service:
service name = BuscarPadronServicio
method name = BuscarPorNumeroDocumento
service found = consultaPadron
reference name web = net.padron.amag.api
VIEW FILE

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:
using Tools = Microsoft.Office.Tools.Excel;
using BuscarPadron = WebServiceConsumer.net.padron.amag.api;

public void DisplayWebServiceResults (string searchterm)(
 paramMissing = System.Type.Missing object;

 / / Clear the current display.
 Tools.NamedRange range = (Tools.NamedRange) this.Controls ["Data"];
 range.Clear ();

 / / Call the Web service.
 BuscarPadron.BuscarPadronServicio BuscarPadron.BuscarPadronServicio service = new ();

)

I'm helping this URL http://msdn.microsoft.com/en-us/library/dd819156 (office.12). Aspx
but I can not do

I am using  Visual Studio 2008
If there is a solution in Excel 2003 no problem

1-web-service.jpg
2-addReferenceWEB.jpg
0
enrique_aeo
Asked:
enrique_aeo
1 Solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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