Excel script delete row if cell is empty (Blank)

Hi


I have a trouble making a script working.

I want to filter a column showing all blanks, and then delete these rows.

#

function main(workbook: ExcelScript.Workbook) {
	let dyReport = workbook.getTable("DyReport");

	// Sort on table: dyReport column index: '14'
	dyReport.getSort().apply([{key: 14, ascending: true}]);

	// Apply checked items filter on table dyReport column Report date
	dyReport.getColumnByName("Report date").getFilter().applyValuesFilter(["="]);

	let selectedSheet = workbook.getActiveWorksheet();

	// Delete extended range obtained by extending down from range 37:37 on selectedSheet
	selectedSheet.getRange("37:37").getExtendedRange(ExcelScript.KeyboardDirection.down).delete(ExcelScript.DeleteShiftDirection.up);

	// Clear filter on table dyReport column "Report date"
	dyReport.getColumnByName("Report date").getFilter().clear();
}

But no matter what I try, i will not work, it dont take all blank rows ?

Regards

Tony