package com.vci.ubcs.starter.bo;
|
|
import java.util.List;
|
|
public class WriteExcelData {
|
private int row;
|
private int col;
|
private Object obj;
|
private boolean merged = false;
|
private int rowTo;
|
private int colTo;
|
private boolean copyStyle = false;
|
private int copyStyleRow;
|
private int copyStyleCol;
|
private boolean center;
|
private boolean formula = false;
|
private boolean nameRefer = false;
|
private boolean validation = false;
|
private List<String> validationDataList;
|
private String validationErrorMsg;
|
private String fontColor;
|
private String align;
|
private String dateFormat;
|
private boolean readOnly;
|
private Integer width;
|
|
public String getFontColor() {
|
return this.fontColor;
|
}
|
|
public void setFontColor(String fontColor) {
|
this.fontColor = fontColor;
|
}
|
|
public String getAlign() {
|
return this.align;
|
}
|
|
public void setAlign(String align) {
|
this.align = align;
|
}
|
|
public List<String> getValidationDataList() {
|
return this.validationDataList;
|
}
|
|
public void setValidationDataList(List<String> validationDataList) {
|
this.validationDataList = validationDataList;
|
}
|
|
public WriteExcelData() {
|
}
|
|
public WriteExcelData(int row, int col, Object obj) {
|
this.row = row;
|
this.col = col;
|
this.obj = obj;
|
}
|
|
public void writeFormula(int row, int col, String foumula) {
|
this.row = row;
|
this.col = col;
|
this.obj = foumula;
|
this.formula = true;
|
}
|
|
public void writeNameRefer(int row, int col, int rowTo, int colTo, String name) {
|
this.row = row;
|
this.col = col;
|
this.obj = name;
|
this.nameRefer = true;
|
this.rowTo = rowTo;
|
this.colTo = colTo;
|
}
|
|
public void writeComboBox(List<String> comboBoxData, int row, int col, int rowTo, int colTo) {
|
this.writeComboBox(comboBoxData, (String)null, row, col, rowTo, colTo);
|
}
|
|
public void writeComboBox(List<String> comboBoxData, String errorMsg, int row, int col, int rowTo, int colTo) {
|
this.validationDataList = comboBoxData;
|
this.validation = true;
|
this.validationErrorMsg = errorMsg;
|
this.row = row;
|
this.col = col;
|
this.rowTo = rowTo;
|
this.colTo = colTo;
|
}
|
|
public void writeUseRefer(String referFormula, int row, int col, int rowTo, int colTo) {
|
this.writeUseRefer(referFormula, (String)null, row, col, rowTo, colTo);
|
}
|
|
public void writeUseRefer(String referFormula, String errorMsg, int row, int col, int rowTo, int colTo) {
|
this.validation = true;
|
this.obj = referFormula;
|
this.validationErrorMsg = errorMsg;
|
this.row = row;
|
this.col = col;
|
this.rowTo = rowTo;
|
this.colTo = colTo;
|
}
|
|
public boolean isReadOnly() {
|
return this.readOnly;
|
}
|
|
public void setReadOnly(boolean readOnly) {
|
this.readOnly = readOnly;
|
}
|
|
public int getRow() {
|
return this.row;
|
}
|
|
public void setRow(int row) {
|
this.row = row;
|
}
|
|
public int getCol() {
|
return this.col;
|
}
|
|
public void setCol(int col) {
|
this.col = col;
|
}
|
|
public Object getObj() {
|
return this.obj;
|
}
|
|
public void setObj(Object obj) {
|
this.obj = obj;
|
}
|
|
public boolean isMerged() {
|
return this.merged;
|
}
|
|
public void setMerged(boolean merged) {
|
this.merged = merged;
|
}
|
|
public int getRowTo() {
|
return this.rowTo;
|
}
|
|
public void setRowTo(int rowTo) {
|
this.rowTo = rowTo;
|
}
|
|
public int getColTo() {
|
return this.colTo;
|
}
|
|
public void setColTo(int colTo) {
|
this.colTo = colTo;
|
}
|
|
public boolean isCopyStyle() {
|
return this.copyStyle;
|
}
|
|
public void setCopyStyle(boolean copyStyle) {
|
this.copyStyle = copyStyle;
|
}
|
|
public int getCopyStyleRow() {
|
return this.copyStyleRow;
|
}
|
|
public void setCopyStyleRow(int copyStyleRow) {
|
this.copyStyleRow = copyStyleRow;
|
}
|
|
public int getCopyStyleCol() {
|
return this.copyStyleCol;
|
}
|
|
public void setCopyStyleCol(int copyStyleCol) {
|
this.copyStyleCol = copyStyleCol;
|
}
|
|
public boolean isCenter() {
|
return this.center;
|
}
|
|
public void setCenter(boolean center) {
|
this.center = center;
|
}
|
|
public boolean isFormula() {
|
return this.formula;
|
}
|
|
public void setFormula(boolean formula) {
|
this.formula = formula;
|
}
|
|
public boolean isNameRefer() {
|
return this.nameRefer;
|
}
|
|
public void setNameRefer(boolean nameRefer) {
|
this.nameRefer = nameRefer;
|
}
|
|
public boolean isValidation() {
|
return this.validation;
|
}
|
|
public void setValidation(boolean validation) {
|
this.validation = validation;
|
}
|
|
public String getValidationErrorMsg() {
|
return this.validationErrorMsg;
|
}
|
|
public void setValidationErrorMsg(String validationErrorMsg) {
|
this.validationErrorMsg = validationErrorMsg;
|
}
|
|
public String getDateFormat() {
|
return this.dateFormat;
|
}
|
|
public void setDateFormat(String dateFormat) {
|
this.dateFormat = dateFormat;
|
}
|
|
public Integer getWidth() {
|
return this.width;
|
}
|
|
public void setWidth(Integer width) {
|
this.width = width;
|
}
|
|
public String toString() {
|
return "WriteExcelData{row=" + this.row + ", col=" + this.col + ", obj=" + this.obj + ", merged=" + this.merged + ", rowTo=" + this.rowTo + ", colTo=" + this.colTo + ", copyStyle=" + this.copyStyle + ", copyStyleRow=" + this.copyStyleRow + ", copyStyleCol=" + this.copyStyleCol + ", center=" + this.center + ", formula=" + this.formula + ", nameRefer=" + this.nameRefer + ", validation=" + this.validation + ", validationDataList=" + this.validationDataList + ", validationErrorMsg='" + this.validationErrorMsg + '\'' + ", fontColor='" + this.fontColor + '\'' + ", align='" + this.align + '\'' + ", dateFormat='" + this.dateFormat + '\'' + ", readOnly=" + this.readOnly + '}';
|
}
|
}
|
