This article guides on how to add tick mark in Excel using Java. You will learn to set up the IDE and get a set of instructions and a sample code to add check mark in Excel using Java. It will assist you in inserting a check mark in different ways.
Steps for Inserting Check Mark in Excel using Java
- Set the IDE to use Aspose.Cells for Java to add a check mark
- Load the license to avoid a watermark in the resultant Excel file
- Create a Workbook and access the target sheet from the collection of sheets in the file
- Use tick mark Unicode value in a cell to display a tick mark with the appropriate font
- For an interactive checkbox, access the collection of checkboxes in the sheet at the specified position
- Set the text prompt of the checkbox and default tick state to true
- Save the workbook with two tick marks in it, one that displays only and the other one as interactive
These steps summarize how to insert a tick in Excel using Java. Import the required classes, load a license for complete product features, create a Workbook, and access the target sheet. Insert one tick mark in a cell by using the Unicode, and insert another interactive checkbox in the next cell by adding a Checkbox control.
Code to Add Checkmark in Excel using Java
The above sample code demonstrates how to put a checkmark in Excel using Java. Note that when a tick symbol is placed in a cell using the Unicode character, an appropriate font is required to display the exact symbol. For inserting an interactive checkbox that can be checked/un-checked, instantiate a CheckBox class object and add it to the collection of checkboxes with proper text and state.
This article has described the process of inserting a check mark in Excel. To add a threaded comment in an Excel file, refer to the article Add Threaded Comments in Excel using Java.