//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["C4:C7"].Merge(); worksheet.Range["C8:C10"].Merge(); worksheet.Range["C4"].Value = "Horizontal Alignment"; worksheet.Range["C4"].HorizontalAlignment = HorizontalAlignment.Center; worksheet.Range["C4"].VerticalAlignment = VerticalAlignment.Center; worksheet.Range["C8"].Value = "Vertical Alignment"; worksheet.Range["C8"].HorizontalAlignment = HorizontalAlignment.Center; worksheet.Range["C8"].VerticalAlignment = VerticalAlignment.Center; worksheet.Range["D4"].Value = "Left"; worksheet.Range["D4"].HorizontalAlignment = HorizontalAlignment.Left; worksheet.Range["D5"].Value = "Center"; worksheet.Range["D5"].HorizontalAlignment = HorizontalAlignment.Center; worksheet.Range["D6"].Value = "Right"; worksheet.Range["D6"].HorizontalAlignment = HorizontalAlignment.Right; worksheet.Range["D7"].Value = "Center Across Selection"; worksheet.Range["D7:E7"].HorizontalAlignment = HorizontalAlignment.CenterContinuous; worksheet.Range["D8"].Value = "Top"; worksheet.Range["D8"].VerticalAlignment = VerticalAlignment.Top; worksheet.Range["D9"].Value = "Center"; worksheet.Range["D9"].VerticalAlignment = VerticalAlignment.Center; worksheet.Range["D10"].Value = "Bottom"; worksheet.Range["D10"].VerticalAlignment = VerticalAlignment.Bottom; worksheet.Range["C4:C10"].ColumnWidth = 20; worksheet.Range["C8:C10"].RowHeight = 30; worksheet.Range["D4:D10"].ColumnWidth = 18; worksheet.Range["C4:C10"].Interior.Color = Color.FromArgb(221,235,247); worksheet.Range["C4:E10"].Borders.LineStyle = BorderLineStyle.Dotted; // Save to an excel file workbook.Save("HAlignVAlign.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range("C4:C7").Merge() worksheet.Range("C8:C10").Merge() worksheet.Range("C4").Value = "Horizontal Alignment" worksheet.Range("C4").HorizontalAlignment = HorizontalAlignment.Center worksheet.Range("C4").VerticalAlignment = VerticalAlignment.Center worksheet.Range("C8").Value = "Vertical Alignment" worksheet.Range("C8").HorizontalAlignment = HorizontalAlignment.Center worksheet.Range("C8").VerticalAlignment = VerticalAlignment.Center worksheet.Range("D4").Value = "Left" worksheet.Range("D4").HorizontalAlignment = HorizontalAlignment.Left worksheet.Range("D5").Value = "Center" worksheet.Range("D5").HorizontalAlignment = HorizontalAlignment.Center worksheet.Range("D6").Value = "Right" worksheet.Range("D6").HorizontalAlignment = HorizontalAlignment.Right worksheet.Range("D7").Value = "Center Across Selection" worksheet.Range("D7:E7").HorizontalAlignment = HorizontalAlignment.CenterContinuous worksheet.Range("D8").Value = "Top" worksheet.Range("D8").VerticalAlignment = VerticalAlignment.Top worksheet.Range("D9").Value = "Center" worksheet.Range("D9").VerticalAlignment = VerticalAlignment.Center worksheet.Range("D10").Value = "Bottom" worksheet.Range("D10").VerticalAlignment = VerticalAlignment.Bottom worksheet.Range("C4:C10").ColumnWidth = 20 worksheet.Range("C8:C10").RowHeight = 30 worksheet.Range("D4:D10").ColumnWidth = 18 worksheet.Range("C4:C10").Interior.Color = Color.FromArgb(221, 235, 247) worksheet.Range("C4:E10").Borders.LineStyle = BorderLineStyle.Dotted ' save to an excel file workbook.Save("HAlignVAlign.xlsx")