packagecom.alibaba.excel.analysis.v07.handlers;importcom.alibaba.excel.context.xlsx.XlsxReadContext;importcom.alibaba.excel.enums.CellDataTypeEnum;importcom.alibaba.excel.metadata.CellData;/** * Cell Value Handler * * @author jipengfei */publicclassCellValueTagHandlerextendsAbstractCellValueTagHandler{@OverrideprotectedvoidsetStringValue(XlsxReadContextxlsxReadContext){// Have to go "sharedStrings.xml" and get itCellDatatempCellData=xlsxReadContext.xlsxReadSheetHolder().getTempCellData();switch(tempCellData.getType()){caseSTRING:StringstringValue=xlsxReadContext.readWorkbookHolder().getReadCache().get(Integer.valueOf(tempCellData.getStringValue()));if(stringValue!=null&&xlsxReadContext.currentReadHolder().globalConfiguration().getAutoTrim()){stringValue=stringValue.trim();}tempCellData.setStringValue(stringValue);break;caseDIRECT_STRING:tempCellData.setType(CellDataTypeEnum.STRING);break;default:}}}