1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
vWorksheet.OleProcedure("Activate");
// 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.OlePropertyGetvWorksheet.OleProcedure("Activate");
// 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);
mesMultiAires.OleProcedure("Select");
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");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);
mesMultiAires.OleProcedure("Select");
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"); |
Partager