import com.spire.xls.*;
import java.awt.*;

public class FindandHighlight {
    public static void main(String[] args) {

        //Load the sample document
        Workbook workbook = new Workbook();
        workbook.loadFromFile("Sample.xlsx");

        //Get the second worksheet
        Worksheet worksheet = workbook.getWorksheets().get(1);

        //Find the text string "Mexico"
        CellRange[] ranges = worksheet.findAllString("Mexico", true, true);

        for (CellRange range : ranges)
        {
            //Set the color to highlight the text
            range.getCellStyle().setColor(Color.yellow);
        }
        
        //Save the document to file
        workbook.saveToFile("output/FindandHighlight.xlsx", ExcelVersion.Version2010);

    }
}