ExcelScript.RemoveDuplicatesResult interface

Remarks

Used by

• ExcelScript.Range: removeDuplicates

Examples

/**
 * This script removes duplicate rows from a range.
 */
function main(workbook: ExcelScript.Workbook) {
 // Get the used range of the active worksheet.
 const usedRange = workbook.getActiveWorksheet().getUsedRange();

 // Remove any row that has a same value in the 0-indexed column as a previous row.
 const removedResults: ExcelScript.RemoveDuplicatesResult = usedRange.removeDuplicates([0], true);

 // Log the count of removed rows.
 console.log(`Rows removed: ${removedResults.getRemoved()}.`);
}

Methods

getRemoved()

getRemoved(): number;

getUniqueRemaining()

getUniqueRemaining(): number;