Java tutorial
/* * Copyright 2014 Objectos, Fbrica de Software LTDA. * * Licensed under the Apache License, Version 2.0 (the "License"); you may not * use this file except in compliance with the License. You may obtain a copy of * the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the * License for the specific language governing permissions and limitations under * the License. */ package br.com.objectos.xls; import java.util.Objects; import org.apache.poi.ss.usermodel.Cell; /** * @author marcio.endo@objectos.com.br (Marcio Endo) */ public class WorksheetRowWriterBoolean extends WorksheetRowWriter { private final boolean trueOrFalse; private String trueText = "x"; private String falseText = null; WorksheetRowWriterBoolean(WorksheetRow row, boolean trueOrFalse) { super(row); this.trueOrFalse = trueOrFalse; } public WorksheetRowWriterStyle asText(String trueValue, String falseValue) { trueText = Objects.requireNonNull(trueValue); falseText = Objects.requireNonNull(falseValue); return this; } public WorksheetRowWriterStyle falseAsText(String falseText) { trueText = null; this.falseText = falseText; return this; } public WorksheetRowWriterStyle trueAsText(String trueText) { this.trueText = trueText; falseText = null; return this; } @Override void write(Cell cell) { cell.setCellType(Cell.CELL_TYPE_BLANK); String cellValue = trueOrFalse ? trueText : falseText; if (cellValue != null) { cell.setCellType(Cell.CELL_TYPE_STRING); cell.setCellValue(cellValue); } } }