Excel.SearchCriteria interface

Комментарии

Набор API: ExcelApi 1.9

Используется

• Excel.Range: find, findOrNullObject

Примеры

await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getItem("Sample");
    const table = sheet.tables.getItem("ExpensesTable");
    const searchRange = table.getRange();
    
    // Search for cells that exactly match "TODO", ignoring case, and starting from the top-left of the range and going forward.
    const searchCriteria: Excel.SearchCriteria = {
        completeMatch: true,
        matchCase: false,
        searchDirection: Excel.SearchDirection.forward
    };
    const foundRange = searchRange.findOrNullObject("TODO", searchCriteria);
    foundRange.load("address");
    await context.sync();

    if (foundRange.isNullObject) {
        console.log("Text not found");
    } else {
        console.log(foundRange.address);
    }
});

Свойства

completeMatch

completeMatch?: boolean;

matchCase

matchCase?: boolean;

searchDirection

searchDirection?: Excel.SearchDirection | "Forward" | "Backwards";