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 org.apache.poi.ss.usermodel.Cell; /** * @author marcio.endo@objectos.com.br (Marcio Endo) */ public class WorksheetRowWriterNumber extends WorksheetRowWriter implements WorksheetRowWriterNumberFormat { private final double value; WorksheetRowWriterNumber(WorksheetRow row, double value) { super(row); this.value = value; } @Override public WorksheetRowWriterNumberFormat format(String formatString) { setFormatString(formatString); return this; } @Override public WorksheetRowWriterStyle asCurrency() { return format("0.00"); } @Override public WorksheetRowWriterNumberFormat asInt() { return format("0"); } @Override public WorksheetRowWriterNumberFormat asPercentage() { return format("0.00%"); } @Override void write(Cell cell) { cell.setCellType(Cell.CELL_TYPE_NUMERIC); cell.setCellValue(value); } }