Finding and replacing data is one of the most useful features in Microsoft Excel, it allows us to quickly locate the position of a particular data and replace it with another data. This blog demonstrates how to find a specified text, replace it with another text and then highlight the result in Excel file in Java using Free Spire.XLS for Java library. Before using the below code, please download Free Spire.XLS for Java package then and import Spire.Xls.jar under the lib folder into your project. import com.spire.xls.CellRange; import com.spire.xls.ExcelVersion; import com.spire.xls.Workbook; import com.spire.xls.Worksheet; import java.awt.*; public class ReplaceAndHightlightText { public static void main(String[] args){ //Create a Workbook instance Workbook workbook = new Workbook(); //Load the Excel file ...
A blog about Microsoft Office and PDF document development using .NET and Java.