Spire.XLS for Java provides you with the ability to shrink text to fit in a cell by using the setShrinkToFit method of the CellStyleObject class. The setShrinkToFit method accepts the following parameter:
boolean: specify whether to shrink text to fit in a cell.
The following example shows how to shrink text to fit in a cell in Excel using Spire.XLS for Java.
import com.spire.xls.*; public class ShrinkTextToFitInACell { public static void main(String []args) throws Exception { //Create a workbook instance Workbook workbook = new Workbook(); //Load the Excel file workbook.loadFromFile("Sample.xlsx"); //Get the first worksheet Worksheet sheet = workbook.getWorksheets().get(0); //Get the cell range to shrink text CellRange cell = sheet.getRange().get("B2:B3"); //Enable “shrink to fit” cell.getCellStyle().setShrinkToFit(true); //Save the file workbook.saveToFile("ShrinkTextToFitInACell.xlsx", ExcelVersion.Version2013); } }
The input Excel:
The output Excel: