Skip to main content

Posts

Remove Duplicate Rows in Excel with Java (Compare All or Selected Columns)

When you combine order exports in Excel, some rows are exact copies. Others describe the same order line at different points in time. A line marked “Awaiting shipment” in the morning export might be “Shipped” in the afternoon. Two rows can also share an order ID because they list different products. Which rows count as duplicates depends on what you want the output to represent. This tutorial shows how to remove duplicate rows in Excel with Java by comparing the entire row, a single column, or a combination of columns. Each example starts with the same order data, so you can see how the choice affects the result. Set Up the Maven Project Add the following repository and dependency to your project's pom.xml . <repositories> <repository> <id> com.e-iceblue </id> <url> https://repo.e-iceblue.com/nexus/content/groups/public/ </url> </repository> </repositories> <dependencies> <dependency> ...

How to Find and Highlight Text in a PDF with Java

  When you review a purchase agreement, the phrase “payment terms” might appear in the main contract and again in an addendum. A Java program can tell you which pages to check, pinpoint each match on the page, and save a highlighted copy to share with a reviewer. The examples below use the same three-page PDF. You can run each one on its own, depending on whether you need page numbers, coordinates, or a marked-up document. Set Up the Maven Project Add this repository and dependency to your project's pom.xml . <repositories> <repository> <id> com.e-iceblue </id> <url> https://repo.e-iceblue.com/nexus/content/groups/public/ </url> </repository> </repositories> <dependencies> <dependency> <groupId> e-iceblue </groupId> <artifactId> spire.pdf </artifactId> <version> 12.10.3 </version> </dependency> </dependencies...