package foundation.io.file.pull;
|
|
import org.apache.poi.ss.usermodel.BuiltinFormats;
|
import org.apache.poi.ss.usermodel.DataFormatter;
|
import org.apache.poi.xssf.model.SharedStringsTable;
|
import org.apache.poi.xssf.model.StylesTable;
|
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
|
import org.apache.poi.xssf.usermodel.XSSFRichTextString;
|
import org.xml.sax.Attributes;
|
|
|
public class CellRuntime {
|
|
private SharedStringsTable sharedStrings;
|
private StylesTable stylesTable;
|
|
private String columnName;
|
private int columIndex;
|
private CellType dataType;
|
private StringBuilder rawData;
|
private int formatIndex;
|
private String formatString;
|
private DataFormatter formatter;
|
protected boolean[] dataFlag;
|
|
|
public CellRuntime(SharedStringsTable sharedStrings, StylesTable stylesTable) {
|
this.sharedStrings = sharedStrings;
|
this.stylesTable = stylesTable;
|
|
rawData = new StringBuilder();
|
formatter = new DataFormatter();
|
}
|
|
public void init(boolean[] dataFlag) {
|
this.dataFlag = dataFlag;
|
}
|
|
public void readAttributes(Attributes attributes) {
|
//1.
|
columnName = attributes.getValue("r");
|
columIndex = columnNameToIndex(columnName);
|
|
//2.
|
dataType = getCellDataType(attributes);
|
}
|
|
@SuppressWarnings("deprecation")
|
public String parseToString() {
|
String value = null;
|
|
if (CellType.BOOL == dataType) {
|
char first = rawData.charAt(0);
|
value = first == '0' ? "false" : "true";
|
}
|
else if (CellType.ERROR == dataType) {
|
value = "error";
|
}
|
else if (CellType.FORMULA == dataType) {
|
value = null;
|
}
|
else if (CellType.INLINESTR == dataType) {
|
XSSFRichTextString rtsi = new XSSFRichTextString(getRawDataString());
|
value = rtsi.toString();
|
}
|
else if (CellType.SSTINDEX == dataType) {
|
String sstIndex = getRawDataString();
|
try {
|
int idx = Integer.parseInt(sstIndex);
|
XSSFRichTextString rtss = new XSSFRichTextString(sharedStrings.getEntryAt(idx));
|
value = rtss.toString();
|
|
if (value != null) {
|
value = value.trim();
|
}
|
}
|
catch (NumberFormatException ex) {
|
}
|
}
|
else if (CellType.NUMBER == dataType) {
|
try {
|
value = getRawDataString();
|
}
|
catch (Exception ex) {
|
value = null;
|
}
|
}
|
else if (CellType.DATE == dataType) {
|
try {
|
value = formatter.formatRawCellContents(Double.parseDouble(getRawDataString()), formatIndex, formatString);
|
}
|
catch (Exception ex) {
|
value = getRawDataString();
|
}
|
|
value = value.trim();
|
}
|
else {
|
value = null;
|
}
|
|
return value;
|
}
|
|
@SuppressWarnings("deprecation")
|
public String parseToFormatString() {
|
String value = null;
|
|
if (CellType.BOOL == dataType) {
|
char first = rawData.charAt(0);
|
value = first == '0' ? "false" : "true";
|
}
|
else if (CellType.ERROR == dataType) {
|
value = "\"error: " + getRawDataString() + '"';
|
}
|
else if (CellType.FORMULA == dataType) {
|
value = rawData.toString();
|
}
|
else if (CellType.INLINESTR == dataType) {
|
XSSFRichTextString rtsi = new XSSFRichTextString(getRawDataString());
|
value = rtsi.toString();
|
}
|
else if (CellType.SSTINDEX == dataType) {
|
String sstIndex = getRawDataString();
|
try {
|
int idx = Integer.parseInt(sstIndex);
|
XSSFRichTextString rtss = new XSSFRichTextString(sharedStrings.getEntryAt(idx));
|
value = rtss.toString();
|
|
if (value != null) {
|
value = value.trim();
|
}
|
}
|
catch (NumberFormatException ex) {
|
}
|
}
|
else if (CellType.NUMBER == dataType) {
|
try {
|
value = getRawDataString();
|
if (this.formatString != null) {
|
value = formatter.formatRawCellContents(Double.parseDouble(value), this.formatIndex, this.formatString);
|
}
|
}
|
catch (Exception ex) {
|
value = "error: " + ex.getMessage();
|
}
|
}
|
else if (CellType.DATE == dataType) {
|
try {
|
value = formatter.formatRawCellContents(Double.parseDouble(getRawDataString()), formatIndex, formatString);
|
}
|
catch (Exception ex) {
|
value = getRawDataString();
|
}
|
|
value = value.trim();
|
}
|
else {
|
value = null;
|
}
|
|
return value;
|
}
|
|
public CellType getDataType() {
|
return dataType;
|
}
|
|
public void setDataType(CellType dataType) {
|
this.dataType = dataType;
|
}
|
|
public int getColumnIndex() {
|
return columIndex;
|
}
|
|
public void clearRawData() {
|
rawData.setLength(0);
|
}
|
|
public int columnNameToIndex(String columnName) {
|
int result = -1;
|
|
for (int i = 0; i < columnName.length(); ++i) {
|
if (Character.isDigit(columnName.charAt(i))) {
|
break;
|
}
|
|
int c = columnName.charAt(i);
|
result = (result + 1) * 26 + c - 'A';
|
}
|
|
return result;
|
}
|
|
public CellType getCellDataType(Attributes attributes) {
|
CellType dataType = CellType.NUMBER;
|
|
String cellType = attributes.getValue("t");
|
String cellStyleStr = attributes.getValue("s");
|
|
if ("b".equals(cellType)) {
|
dataType = CellType.BOOL;
|
}
|
else if ("e".equals(cellType)) {
|
dataType = CellType.ERROR;
|
}
|
else if ("inlineStr".equals(cellType)) {
|
dataType = CellType.INLINESTR;
|
}
|
else if ("s".equals(cellType)) {
|
dataType = CellType.SSTINDEX;
|
}
|
else if ("str".equals(cellType)) {
|
dataType = CellType.FORMULA;
|
}
|
|
if (cellStyleStr != null) {
|
int styleIndex = Integer.parseInt(cellStyleStr);
|
XSSFCellStyle style = stylesTable.getStyleAt(styleIndex);
|
formatIndex = style.getDataFormat();
|
formatString = style.getDataFormatString();
|
|
if ("m/d/yy" == formatString) {
|
dataType = CellType.DATE;
|
formatString = "yyyy-MM-dd";
|
}
|
if (formatString == null) {
|
dataType = CellType.NULL;
|
formatString = BuiltinFormats.getBuiltinFormat(formatIndex);
|
}
|
}
|
|
return dataType;
|
}
|
|
public void appendValue(char[] ch, int start, int length) {
|
rawData.append(ch, start, length);
|
}
|
|
public String getRawDataString() {
|
String result = rawData.toString();
|
|
if (result == null) {
|
return null;
|
}
|
|
return result.trim();
|
}
|
|
public boolean isIgnore() {
|
return false;
|
//return !dataFlag[columIndex];
|
}
|
}
|
