// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("C4:C7").merge(); worksheet.getRange("C8:C10").merge(); worksheet.getRange("C4").setValue("Horizontal Alignment"); worksheet.getRange("C4").setHorizontalAlignment(HorizontalAlignment.Center); worksheet.getRange("C4").setVerticalAlignment(VerticalAlignment.Center); worksheet.getRange("C8").setValue("Vertical Alignment"); worksheet.getRange("C8").setHorizontalAlignment(HorizontalAlignment.Center); worksheet.getRange("C8").setVerticalAlignment(VerticalAlignment.Center); worksheet.getRange("D4").setValue("Left"); worksheet.getRange("D4").setHorizontalAlignment(HorizontalAlignment.Left); worksheet.getRange("D5").setValue("Center"); worksheet.getRange("D5").setHorizontalAlignment(HorizontalAlignment.Center); worksheet.getRange("D6").setValue("Right"); worksheet.getRange("D6").setHorizontalAlignment(HorizontalAlignment.Right); worksheet.getRange("D7").setValue("Center Across Selection"); worksheet.getRange("D7:E7").setHorizontalAlignment(HorizontalAlignment.CenterContinuous); worksheet.getRange("D8").setValue("Top"); worksheet.getRange("D8").setVerticalAlignment(VerticalAlignment.Top); worksheet.getRange("D9").setValue("Center"); worksheet.getRange("D9").setVerticalAlignment(VerticalAlignment.Center); worksheet.getRange("D10").setValue("Bottom"); worksheet.getRange("D10").setVerticalAlignment(VerticalAlignment.Bottom); worksheet.getRange("C4:C10").setColumnWidth(20.0); worksheet.getRange("C8:C10").setRowHeight(30.0); worksheet.getRange("D4:D10").setColumnWidth(18.0); worksheet.getRange("C4:C10").getInterior().setColor(Color.FromArgb(221,235,247)); worksheet.getRange("C4:E10").getBorders().setLineStyle(BorderLineStyle.Dotted); // Save to an excel file workbook.save("HAlignVAlign.xlsx");