Excel - Power Query - Power Pivot - VBA

Pages

Office Script

Opérations Office Script

Opérations Office Script

Opération

Code

Column 3

Duplique une feuille

let feuil1 = workbook.getWorksheet("Feuil1");

let feuil1_2 = feuil1.copy(ExcelScript.WorksheetPositionType.before, feuil1);

Collage valeur

let tblData = workbook.getTable("Tableau_Data");

let feuil1 = workbook.getWorksheet("Feuil1");

feuil1.getRange("A1").copyFrom(tblData.getRange(), ExcelScript.RangeCopyType.values, false, false);

Obtenir plage tableau

workbook.getTable("Tableau_passerelles9")

There are no rows in this table

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.