Insert Textbox to Excel Worksheet Using Java

Text box allows people to enter text in it and move it arbitrarily. It can be used in some areas that need to be emphasized or highlighted. This article will demonstrate how to add textbox into Excel worksheet with Free Spire.XLS for Java. We could fill in the textbox with text and image.

Installation (2 Method)
1# Download the free library 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>

Sample Code

import com.spire.xls.*;
import com.spire.xls.core.ITextBox;
import com.spire.xls.core.ITextBoxShape;

public class ExcelTextbox {
public static void main(String[] args) throws Exception {

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

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

//Insert the textbox with text
ITextBox textBox = sheet.getTextBoxes().addTextBox(5, 3, 70, 196);
textBox.setText("Insert TextBox in Excel");
textBox.setHAlignment(CommentHAlignType.Center);
textBox.setVAlignment(CommentVAlignType.Center);

//Insert the textbox with picture
ITextBoxShape shape = sheet.getTextBoxes().addTextBox(5, 8, 128, 196);
shape.getFill().customPicture("C:\\Users\\Administrator\\Desktop\\java.png");
shape.getFill().setFillType(ShapeFillType.Picture);

//Save the Excel file
workbook.saveToFile("output/TextBox.xlsx", ExcelVersion.Version2010);
}
}

Result