Koşullu Biçimlendirme

Koşullu Biçimlendirme Uygulama

Aspose.Cells, koşullu biçimlendirmeyi iki şekilde destekler:

Tasarımcı Elek Tablosu Kullanma

Geliştiriciler, Microsoft Excel’de koşullu biçimlendirme içeren bir tasarımcı elektronik tablo oluşturabilir ve ardından bu elektronik tabloyu Aspose.Cells ile açabilir. Aspose.Cells, tasarımcı elektronik tabloyu yükler ve kaydeder, tüm koşullu biçimlendirme ayarlarını korur. Tasarımcı elektronik tablolar hakkında daha fazla bilgi edinmek için Tasarım Elektronik Tablosu Nedir başlıklı makaleyi okuyun.

Çalışma Zamanında Koşullu Biçimlendirme Uygulama

Aspose.Cells, çalışma zamanında koşullu biçimlendirme uygulamayı destekler.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// Path to source file
String dataDir = Utils.getSharedDataDir(ConditionalFormattingatRuntime.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();
Worksheet sheet = workbook.getWorksheets().get(0);
ConditionalFormattingCollection cfs = sheet.getConditionalFormattings();
// The first method:adds an empty conditional formatting
int index = cfs.add();
FormatConditionCollection fcs = cfs.get(index);
// Sets the conditional format range.
CellArea ca1 = new CellArea();
ca1.StartRow = 0;
ca1.StartColumn = 0;
ca1.EndRow = 0;
ca1.EndColumn = 0;
CellArea ca2 = new CellArea();
ca2.StartRow = 0;
ca2.StartColumn = 0;
ca2.EndRow = 0;
ca2.EndColumn = 0;
CellArea ca3 = new CellArea();
ca3.StartRow = 0;
ca3.StartColumn = 0;
ca3.EndRow = 0;
ca3.EndColumn = 0;
fcs.addArea(ca1);
fcs.addArea(ca2);
fcs.addArea(ca3);
// Sets condition formulas.
int conditionIndex = fcs.addCondition(FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "=A2", "100");
FormatCondition fc = fcs.get(conditionIndex);
int conditionIndex2 = fcs.addCondition(FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "50", "100");
// Saving the Excel file
workbook.save(dataDir + "CFAtRuntime_out.xls");

Yazı Tipi Ayarı

Microsoft Excel’de Yazı Tiplerini Ayarlama

todo:image_alt_text

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// Path to source file
String dataDir = Utils.getSharedDataDir(SettingFontStyle.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();
FormatCondition fc = null;
Style style = fc.getStyle();
Font font = style.getFont();
font.setItalic(true);
font.setBold(true);
font.setStrikeout(true);
font.setUnderline(FontUnderlineType.DOUBLE);
font.setColor(Color.getBlack());
fc.setStyle(style);
// Saving the Excel file
workbook.save(dataDir + "SFontStyle_out.xls");

Sınır Ayarı

Microsoft Excel’de Kenarlıkları Ayarlama

todo:image_alt_text

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// Path to source file
String dataDir = Utils.getSharedDataDir(SetBorder.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();
Worksheet sheet = workbook.getWorksheets().get(0);
// Adds an empty conditional formatting
int index = sheet.getConditionalFormattings().add();
FormatConditionCollection fcs = sheet.getConditionalFormattings().get(index);
// Sets the conditional format range.
CellArea ca = new CellArea();
ca.StartRow = 0;
ca.EndRow = 5;
ca.StartColumn = 0;
ca.EndColumn = 3;
fcs.addArea(ca);
// Adds condition.
int conditionIndex = fcs.addCondition(FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "50", "100");
// Sets the background color.
FormatCondition fc = fcs.get(conditionIndex);
Style style = fc.getStyle();
style.setBorder(BorderType.LEFT_BORDER, CellBorderType.DASHED, Color.fromArgb(0, 255, 255));
style.setBorder(BorderType.TOP_BORDER, CellBorderType.DASHED, Color.fromArgb(0, 255, 255));
style.setBorder(BorderType.RIGHT_BORDER, CellBorderType.DASHED, Color.fromArgb(0, 255, 255));
style.setBorder(BorderType.RIGHT_BORDER, CellBorderType.DASHED, Color.fromArgb(255, 255, 0));
fc.setStyle(style);

Desen Ayarı

Microsoft Excel’de Bir Hücre Deseni Ayarlama

todo:image_alt_text

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// Path to source file
String dataDir = Utils.getSharedDataDir(SetPattern.class) + "data/";
// Instantiating a Workbook object
Workbook workbook = new Workbook();
Worksheet sheet = workbook.getWorksheets().get(0);
// Adds an empty conditional formatting
int index = sheet.getConditionalFormattings().add();
FormatConditionCollection fcs = sheet.getConditionalFormattings().get(index);
// Sets the conditional format range.
CellArea ca = new CellArea();
ca.StartRow = 0;
ca.EndRow = 5;
ca.StartColumn = 0;
ca.EndColumn = 3;
fcs.addArea(ca);
// Adds condition.
int conditionIndex = fcs.addCondition(FormatConditionType.CELL_VALUE, OperatorType.BETWEEN, "50", "100");
// Sets the background color.
FormatCondition fc = fcs.get(conditionIndex);
Style style = fc.getStyle();
style.setPattern(BackgroundType.REVERSE_DIAGONAL_STRIPE);
style.setForegroundColor(Color.fromArgb(255, 255, 0));
style.setBackgroundColor(Color.fromArgb(0, 255, 255));
fc.setStyle(style);

Gelişmiş Konular