Highlight Highest and Lowest Value in Excel Using Java

<repositories>
<repository>
<id>com.e-iceblue</id>
<name>e-iceblue</name>
<url>http://repo.e-iceblue.com/nexus/content/groups/public/</url>
</repository>
</repositories>
<dependencies>
<dependency>
<groupId>e-iceblue</groupId>
<artifactId>spire.xls.free</artifactId>
<version>3.9.1</version>
</dependency>
</dependencies>
import com.spire.xls.*;

import java.awt.*;

public class HighlightTopBottom {

public static void main(String[] args) {

//Create a Workbook object
Workbook workbook = new Workbook();

//Load the sample Excel file
workbook.loadFromFile("test.xlsx");

//Get the first worksheet
Worksheet sheet = workbook.getWorksheets().get(0);

//Apply conditional formatting to range "D1:D9" to highlight the highest value
ConditionalFormatWrapper format1 = sheet.getCellRange("D1:D9").getConditionalFormats().addCondition();
format1.setFormatType(ConditionalFormatType.TopBottom);
format1.getTopBottom().setType(TopBottomType.Top);
format1.getTopBottom().setRank(1);
format1.setBackColor(Color.red);

//Apply conditional formatting to range "D1:D9" to highlight the lowest value
ConditionalFormatWrapper format2 = sheet.getCellRange("D1:D9").getConditionalFormats().addCondition();
format2.setFormatType(ConditionalFormatType.TopBottom);
format2.getTopBottom().setType(TopBottomType.Bottom);
format2.getTopBottom().setRank(1);
format2.setBackColor(Color.CYAN);

//Save the document
workbook.saveToFile("output/HighestLowestValue.xlsx", ExcelVersion.Version2016);
}
}

--

--

--

Sharing Java Code

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

My Understanding of Serverless

Java code conventions

ASP.NET Core MVC WebApplication

Introducing Square In-App Payments SDK

MILLER CIRCUIT

Parallels For Mac License Agreement

TryHackMe: CTF Collection Vol. 2 Writeup

THM Challenge logo

Agile behind the shadow of the Waterfall

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Andrew Wilson

Andrew Wilson

Sharing Java Code

More from Medium

Beginners Guide to Java Programming

Java 學習記錄126 — SQL Injection Attacks and Prepared Statements

Getting Java Thread Cpu Usage

JDBC | MySQL Connection

java mysql database connection