Discussion :

[red210]

Bonjour a tous,

Voila j'aimerai savoir comment recuperer un objet "Microsoft.Office.Tools.Excel.Workbook" depuis mon classeur courrant ouvert, seulement depuis "Globals.ThisAddIn.Application.Workbooks.get_Item(1)", je recupere un objet "Microsoft.Office.Interop.Excel.Workbook"...

J'ai lu la page msdn sur les controles et element hotes mais sincerement c'est a rendre n'importe qui chevre.

J'ai besoin d'aide !! merci

[red210]

Programmatically Creating Host Items and Host Controls

Host items are not created automatically when you programmatically create a new document or worksheet at run time. For example, if you add a Word document at run time, it will be of the type Microsoft.Office.Interop.Word.Document rather than Microsoft.Office.Tools.Word.Document. Similarly, when you add a worksheet programmatically at run time using the Add method, you get a worksheet of the type Microsoft.Office.Interop.Excel.Worksheet not Microsoft.Office.Tools.Excel.Worksheet. Host controls can be created programmatically, but they can only be added to host items. If you programmatically create a document or worksheet, the item is not a host item, and you will not be able to add host controls to the programmatically created document or worksheet. You can create host items only at design time.

You can programmatically add host controls to a host item by using one of the Add<Control> methods. For example, to add a NamedRange control to your document, use the AddNamedRange method. Only the following host controls can be created programmatically

Comment les mec ont t'ils reflechi ? Il se sont leve le matin en se disant... ouais on pourra ajouter des combo au moment du design (OUT donc les addin excel).... enfin bref...

[red210]

Mon but final et inavoue jusqu'a present etant de mettre une combobox dans une cellule d'une feuille existante...

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
 
Excel.Sheets exSheets =  Globals.ThisAddIn.Application.Worksheets;      
Excel.Worksheet exWs = exSheets .get_Item(1);
Excel.Range range = exWs .get_Range("A1", "A1");
 
range.Validation.Add(Excel.XlDVType.xlValidateList, 
                             System.Type.Missing,
                             System.Type.Missing, 
                             "bonjour;salut",
                              System.Type.Missing);
 
range.Validation.IgnoreBlank = false;
range.Validation.InCellDropdown = true;

Ce qui me cree bien une liste dans ma cellule, mais j'aimerai une vrai combobox comme quand on passe par le designer ? est ce possible depuis un pluggin excel ???

Run time. Host items are not automatically created at run time. If you add workbooks, worksheets, or chart sheets at run time, they are native Excel objects and do not have the additional capabilities that host items provide. You can programmatically add many of the host controls. For more information, see Host Items and Host Controls Overview.

Mais alors comment creer des host items et host controls par programmation ??

Merci