Question 1: You can use the XML support in Excel to bind your spreadsheet to an XML file with a schema. Then, you can add logic in your InfoPath form to import the XML by specifying the XSD in your manifest.xsf file.
Question 2: The short answer is that you can't. Controls need to be added to the form at design time. You can't manipulate UI controls by code behind.
How to use InfoPath with VS .Net
Dave Kafato
Try to look here:
http://msdn.microsoft.com/library/default.asp url=/library/en-us/odc_2003_ta/html/odc_ancInfo.asp
With VSTO 3, it will be more simple to use and develop applications for Office Product
Take a look also here:
http://blogs.msdn.com/vsto/
and
http://blogs.msdn.com/vsto2/default.aspx
And to finish, here: http://msdn.microsoft.com/office/understanding/vsto/
HTH.
Bye.
cdwm
Thanks for Your help. I could set up the InfoPath toolkit with VS.net.
I need more help.
How to import the Excel data in InfoPath page with the help of VS.net
How to generate runtime controls in the InfoPath forms
Again thanks for your help.
awdon
Thanks for your help. I have visited those links. Now I am able to understand how to work with InfoPath.
I need one more help. How can I export Excel data in InforPath page with VS .Net.
Again thanks for Your help.
EdwMad
Question 1:
You can use the XML support in Excel to bind your spreadsheet to an XML file with a schema. Then, you can add logic in your InfoPath form to import the XML by specifying the XSD in your manifest.xsf file.
Question 2:
The short answer is that you can't. Controls need to be added to the form at design time. You can't manipulate UI controls by code behind.
Hope that it helps.
Regards,
Franck Dauche
Gopal Ramamoorthy
Right now, if you have VS.Net 2003 and InfoPath 2003, you need to install a toolkit to be able to use VB.Net or C# as code behind InfoPath:
http://www.microsoft.com/downloads/details.aspx familyid=7e9ebc57-e115-4cac-9986-a712e22879bb&displaylang=en
Regards,
Franck Dauche