enrique_aeo
asked on
call web services from excel 2007
I have this store procedure
alter PROCEDURE padron.BuscarPorNumeroDocu
@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
alter PROCEDURE padron.BuscarPorNumeroDocu
@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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER