// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1").setValue("Pattern Name"); worksheet.getRange("B1").setValue("Pattern"); worksheet.getRange("C1").setValue("Pattern Color"); // LightUp worksheet.getRange("A2").setValue("LightUp"); worksheet.getRange("B2").getInterior().setPattern(Pattern.LightUp); worksheet.getRange("C2").getInterior().setPattern(Pattern.LightUp); worksheet.getRange("C2").getInterior().setColor(Color.GetRed()); worksheet.getRange("C2").getInterior().setPatternColor(Color.GetGreen()); // LightDown worksheet.getRange("A3").setValue("LightDown"); worksheet.getRange("B3").getInterior().setPattern(Pattern.LightDown); worksheet.getRange("C3").getInterior().setPattern(Pattern.LightDown); worksheet.getRange("C3").getInterior().setColor(Color.GetRed()); worksheet.getRange("C3").getInterior().setPatternColor(Color.GetGreen()); // LightHorizontal worksheet.getRange("A4").setValue("LightHorizontal"); worksheet.getRange("B4").getInterior().setPattern(Pattern.LightHorizontal); worksheet.getRange("C4").getInterior().setPattern(Pattern.LightHorizontal); worksheet.getRange("C4").getInterior().setColor(Color.GetRed()); worksheet.getRange("C4").getInterior().setPatternColor(Color.GetGreen()); // LightVertical worksheet.getRange("A5").setValue("LightVertical"); worksheet.getRange("B5").getInterior().setPattern(Pattern.LightVertical); worksheet.getRange("C5").getInterior().setPattern(Pattern.LightVertical); worksheet.getRange("C5").getInterior().setColor(Color.GetRed()); worksheet.getRange("C5").getInterior().setPatternColor(Color.GetGreen()); // Gray75 worksheet.getRange("A6").setValue("Gray75"); worksheet.getRange("B6").getInterior().setPattern(Pattern.Gray75); worksheet.getRange("C6").getInterior().setPattern(Pattern.Gray75); worksheet.getRange("C6").getInterior().setColor(Color.GetRed()); worksheet.getRange("C6").getInterior().setPatternColor(Color.GetGreen()); // Gray50 worksheet.getRange("A7").setValue("Gray50"); worksheet.getRange("B7").getInterior().setPattern(Pattern.Gray50); worksheet.getRange("C7").getInterior().setPattern(Pattern.Gray50); worksheet.getRange("C7").getInterior().setColor(Color.GetRed()); worksheet.getRange("C7").getInterior().setPatternColor(Color.GetGreen()); // Gray25 worksheet.getRange("A8").setValue("Gray25"); worksheet.getRange("B8").getInterior().setPattern(Pattern.Gray25); worksheet.getRange("C8").getInterior().setPattern(Pattern.Gray25); worksheet.getRange("C8").getInterior().setColor(Color.GetRed()); worksheet.getRange("C8").getInterior().setPatternColor(Color.GetGreen()); // Gray16 worksheet.getRange("A9").setValue("Gray16"); worksheet.getRange("B9").getInterior().setPattern(Pattern.Gray16); worksheet.getRange("C9").getInterior().setPattern(Pattern.Gray16); worksheet.getRange("C9").getInterior().setColor(Color.GetRed()); worksheet.getRange("C9").getInterior().setPatternColor(Color.GetGreen()); // Gray8 worksheet.getRange("A10").setValue("Gray8"); worksheet.getRange("B10").getInterior().setPattern(Pattern.Gray8); worksheet.getRange("C10").getInterior().setPattern(Pattern.Gray8); worksheet.getRange("C10").getInterior().setColor(Color.GetRed()); worksheet.getRange("C10").getInterior().setPatternColor(Color.GetGreen()); // Horizontal worksheet.getRange("A11").setValue("Horizontal"); worksheet.getRange("B11").getInterior().setPattern(Pattern.Horizontal); worksheet.getRange("C11").getInterior().setPattern(Pattern.Horizontal); worksheet.getRange("C11").getInterior().setColor(Color.GetRed()); worksheet.getRange("C11").getInterior().setPatternColor(Color.GetGreen()); // Vertical worksheet.getRange("A12").setValue("Vertical"); worksheet.getRange("B12").getInterior().setPattern(Pattern.Vertical); worksheet.getRange("C12").getInterior().setPattern(Pattern.Vertical); worksheet.getRange("C12").getInterior().setColor(Color.GetRed()); worksheet.getRange("C12").getInterior().setPatternColor(Color.GetGreen()); // Down worksheet.getRange("A13").setValue("Down"); worksheet.getRange("B13").getInterior().setPattern(Pattern.Down); worksheet.getRange("C13").getInterior().setPattern(Pattern.Down); worksheet.getRange("C13").getInterior().setColor(Color.GetRed()); worksheet.getRange("C13").getInterior().setPatternColor(Color.GetGreen()); // Up worksheet.getRange("A14").setValue("Up"); worksheet.getRange("B14").getInterior().setPattern(Pattern.Up); worksheet.getRange("C14").getInterior().setPattern(Pattern.Up); worksheet.getRange("C14").getInterior().setColor(Color.GetRed()); worksheet.getRange("C14").getInterior().setPatternColor(Color.GetGreen()); // Checker worksheet.getRange("A15").setValue("Checker"); worksheet.getRange("B15").getInterior().setPattern(Pattern.Checker); worksheet.getRange("C15").getInterior().setPattern(Pattern.Checker); worksheet.getRange("C15").getInterior().setColor(Color.GetRed()); worksheet.getRange("C15").getInterior().setPatternColor(Color.GetGreen()); // SemiGray75 worksheet.getRange("A16").setValue("SemiGray75"); worksheet.getRange("B16").getInterior().setPattern(Pattern.SemiGray75); worksheet.getRange("C16").getInterior().setPattern(Pattern.SemiGray75); worksheet.getRange("C16").getInterior().setColor(Color.GetRed()); worksheet.getRange("C16").getInterior().setPatternColor(Color.GetGreen()); // Grid worksheet.getRange("A17").setValue("Grid"); worksheet.getRange("B17").getInterior().setPattern(Pattern.Grid); worksheet.getRange("C17").getInterior().setPattern(Pattern.Grid); worksheet.getRange("C17").getInterior().setColor(Color.GetRed()); worksheet.getRange("C17").getInterior().setPatternColor(Color.GetGreen()); // CrissCross worksheet.getRange("A18").setValue("CrissCross"); worksheet.getRange("B18").getInterior().setPattern(Pattern.CrissCross); worksheet.getRange("C18").getInterior().setPattern(Pattern.CrissCross); worksheet.getRange("C18").getInterior().setColor(Color.GetRed()); worksheet.getRange("C18").getInterior().setPatternColor(Color.GetGreen()); worksheet.getRange("A1").setColumnWidth(15); worksheet.getRange("B1:C1").setColumnWidth(20); IRange rangeA1A18 = worksheet.getRange("A1:A18"); rangeA1A18.setRowHeight(35); IStyle styleA1A18 = rangeA1A18.getStyle(); styleA1A18.setVerticalAlignment(VerticalAlignment.Center); styleA1A18.getFont().setSize(16); // Save to a pdf file workbook.save("CellPatternFillPDF.pdf");