DEV Community

CodeSharing
CodeSharing

Posted on

Add Borders to Cells in Excel Using Java

#java #excel #border

This article will introduce how to add borders to cells in an Excel file using a 3rd party free library.

Installation (2 Method)
1# Download the free library (Free Spire.XLS for Java) and unzip it, then add the Spire.Xls.jar file to your project as dependency.
2# You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.

<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>
Enter fullscreen mode Exit fullscreen mode

Sample Code

import com.spire.xls.*; import java.awt.*; public class AddBorders { public static void main(String[] args){ //Create a workbook instance Workbook workbook = new Workbook(); //Load the Excel file workbook.loadFromFile("C:\\Users\\Administrator\\Desktop\\input.xlsx"); //Get the first worksheet Worksheet sheet = workbook.getWorksheets().get(0); //Get the cell range that you want to apply border style CellRange cr = sheet.getCellRange(sheet.getFirstRow(), sheet.getFirstColumn(), sheet.getLastRow(), sheet.getLastColumn()); //Apply border style cr.getBorders().setLineStyle(LineStyleType.Double); cr.getBorders().getByBordersLineType(BordersLineType.DiagonalDown).setLineStyle(LineStyleType.None); cr.getBorders().getByBordersLineType(BordersLineType.DiagonalUp).setLineStyle(LineStyleType.None); cr.getBorders().setColor(Color.BLUE); //Save the resultant file workbook.saveToFile("SetBorder.xlsx", ExcelVersion.Version2010); } }
Enter fullscreen mode Exit fullscreen mode

Before
input

After
border

Top comments (0)