Power Platform Community Forum Thread Details

Hi,

Trying to run a script through power automate. I am getting the error on this - Table.getRangeBetweenHeaderAndTotal().delete(0);

function main(workbook: ExcelScript.Workbook) {

let Table = workbook.getTable("Table_query");

let rowcount = Table.getRowCount();

Table.getAutoFilter().remove();

Table.getRangeBetweenHeaderAndTotal().delete(0);

}

where am I going wrong?

Categories:

Office Scripts - Range delete: This won't work because it would move cells in a table on your worksheet.