FAQ C++ BuilderConsultez toutes les FAQ

vRange.OlePropertySet("Name", "ricky81");

1
2
Variant vOtherRange; 
vOtherRange = vWorksheet.OlePropertyGet("Range", "ricky81");

1
2
3
Variant vNames, vRange; 
vNames = vWorksheet.OlePropertyGet("Names"); 
vRange = vNames.OleFunction("Item", "ricky81").OlePropertyGet("RefersToRange")

1
2
Variant vNewRange; 
vNewRange = vRange.OlePropertyGet("Resize", rowsize, columnsize);

1
2
Variant vNewRange; 
vNewRange = vRange.OleProcedure("Offset", rowoffset, columnoffset);

1
2
vRange.OleProcedure("Copy", vCell); 
// le Variant vCell représente le coin supérieur gauche destination

1
2
Variant vRange; 
vRange = vMSExcel.OleFunction("Union", vCell1, vCell2, vCell3);

vRange = vMSExcel.OleFunction("Intersect", vRange1, vRange2, vRange3);

1
2
Variant vSelection; 
vSelection = vRange.OlePropertyGet("Address");

1
2
Variant vRegion; 
vRegion = vRange.OlePropertyGet("CurrentRegion");

1
2
Variant vBlankCells; 
vBlankCells = vRange.OlePropertyGet("SpecialCells", xlCellTypeBlanks);

1
2
Variant vTextCells; 
vTextCells = vRange.OlePropertyGet("SpecialCells", xlCellTypeConstants, xlTextValues);

1
2
Variant vNumbersCells; 
vNumbersCells = vRange.OlePropertyGet("SpecialCells", xlCellTypeConstants, xlNumbers);

1
2
Variant vFormulaCells; 
vFormulaCells = vRange.OlePropertyGet("SpecialCells", xlCellTypeFormulas);

1
2
3
4
//on sélectionne la plage de cellules délimitées par vCell1 et vCell2 
// vCell1 et vCell2 sont des Variant représentant des cellules 
// vWorksheet est un Variant représentant une feuille 
vWorksheet.OlePropertyGet("Range", vCell1, vCell2).OleFunction("Select");

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
vWorksheet.OleProcedure("Activate"); 
  
// définition des plages 
// vMSExcel.OlePropertyGet("Range", "C5:D9,G9:H16,B14:D18"); 
//Variant Aire1 = vWorksheet.OlePropertyGet("Range", "A1:B2"); 
Variant Aire1 = vWorksheet.OlePropertyGet("Range", vWorksheet.OlePropertyGet("Cells",1,1),vWorksheet.OlePropertyGet("Cells",2,2)); 
//Variant Aire2 = vWorksheet.OlePropertyGet("Range", "C3:D4"); 
Variant Aire2 = vWorksheet.OlePropertyGet("Range", vWorksheet.OlePropertyGet("Cells",3,3),vWorksheet.OlePropertyGet("Cells",4,4)); 
//Variant Aire3 = vWorksheet.OlePropertyGet("Range", "B8:F14"); 
Variant Aire3 = vWorksheet.OlePropertyGet("Range", vWorksheet.OlePropertyGet("Cells",8,2),vWorksheet.OlePropertyGet("Cells",14,6)); 
Variant mesMultiAires =  vMSExcel.OleFunction("Union", Aire1, Aire2, Aire3); 
  
// sélection des plages 
mesMultiAires.OleProcedure("Select"); 
  
// on récupère le NB de lignes et de colonnes 
Variant lign1 = Aire1.OlePropertyGet("Rows").OlePropertyGet("Count"); 
Variant colon1 = Aire1.OlePropertyGet("Columns").OlePropertyGet("Count"); 
Variant lign2 = Aire2.OlePropertyGet("Rows").OlePropertyGet("Count"); 
Variant colon2 = Aire2.OlePropertyGet("Columns").OlePropertyGet("Count"); 
Variant lign3 = Aire3.OlePropertyGet("Rows").OlePropertyGet("Count"); 
Variant colon3 = Aire3.OlePropertyGet("Columns").OlePropertyGet("Count");