devutility.external.poi.utils.CellStyleUtils Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of devutility.external.poi Show documentation

Some utilities for Apache POI.

The newest version!

package devutility.external.poi.utils;

import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Workbook;

public class CellStyleUtils {
	/**
	 * Clone CellStyle by provided Workbook and CellStyle.
	 * @param workbook: Workbook object.
	 * @param cellStyle: CellStyle object.
	 * @return CellStyle
	 */
	public static CellStyle clone(Workbook workbook, CellStyle cellStyle) {
		CellStyle newCellStyle = workbook.createCellStyle();
		newCellStyle.setAlignment(cellStyle.getAlignment());
		newCellStyle.setBorderBottom(cellStyle.getBorderBottom());
		newCellStyle.setBorderLeft(cellStyle.getBorderLeft());
		newCellStyle.setBorderRight(cellStyle.getBorderRight());
		newCellStyle.setBorderTop(cellStyle.getBorderTop());
		newCellStyle.setBottomBorderColor(cellStyle.getBottomBorderColor());
		newCellStyle.setDataFormat(cellStyle.getDataFormat());
		newCellStyle.setFillBackgroundColor(cellStyle.getFillBackgroundColor());
		newCellStyle.setFillForegroundColor(cellStyle.getFillForegroundColor());
		newCellStyle.setFillPattern(cellStyle.getFillPattern());
		newCellStyle.setHidden(cellStyle.getHidden());
		newCellStyle.setIndention(cellStyle.getIndention());
		newCellStyle.setLeftBorderColor(cellStyle.getLeftBorderColor());
		newCellStyle.setLocked(cellStyle.getLocked());
		newCellStyle.setQuotePrefixed(cellStyle.getQuotePrefixed());
		newCellStyle.setRightBorderColor(cellStyle.getRightBorderColor());
		newCellStyle.setRotation(cellStyle.getRotation());
		newCellStyle.setShrinkToFit(cellStyle.getShrinkToFit());
		newCellStyle.setTopBorderColor(cellStyle.getTopBorderColor());
		newCellStyle.setVerticalAlignment(cellStyle.getVerticalAlignment());
		newCellStyle.setWrapText(cellStyle.getWrapText());
		return newCellStyle;
	}
}