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); } } 
Top comments (0)