Solved

web service in excel 2007

Posted on 2010-08-20
1
521 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

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
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
1 Comment
 
LVL 36

Accepted Solution

by:
Miguel Oz earned 500 total points
ID: 33490296
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

752 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