// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1:C1").merge(); worksheet.getRange("A1:C1").setValue("Enhancement of MS Excel auto fit, Auto fit a row contains merged cell"); worksheet.getRange("A1:C1").setWrapText(true); worksheet.getRange("A1:C1").getRows().autoFit(true); // Save to an excel file workbook.save("AutoFitContainMergedCell.xlsx");