Find text

The example shows you how to find text in a workbook. Find returns a FindResult object for every occurrence, which tells you the matched text, its position, the sheet and the cell it belongs to and the part of the workbook it was found in. Cells, rich text runs, comments, headers, footers and the text of shapes are searched.

import java.util.List;

import com.independentsoft.office.spreadsheet.FindResult;
import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            List<FindResult> results = book.find("2025");

            System.out.println(results.size() + " occurrences found.");

            for (FindResult result : results)
            {
                String reference = result.getCell() != null ? result.getCell().getReference() : "";

                System.out.println(result.getSheet().getName() + "!" + reference + " : " + result.getText() + " (" + result.getStory() + ")");
            }
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

import com.independentsoft.office.spreadsheet.FindResult;
import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\input.xlsx");

            FindResult result = book.findFirst("{total}");

            if (result != null)
            {
                //replace the first occurrence only, the format of the cell is preserved
                result.replace("1,250.00");

                book.save("c:\\test\\output.xlsx", true);
            }
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

JSpreadsheet > Tutorial > Find text

Need help? Ask our developers: