com.alibaba.excel包教程：Excel数据导出加工进阶篇

1. import com.alibaba.excel.converters.Converter;
2. import com.alibaba.excel.metadata.GlobalConfiguration;
3. import com.alibaba.excel.metadata.data.WriteCellData;
4. import com.alibaba.excel.metadata.property.ExcelContentProperty;
5. 
6. import java.text.DecimalFormat;
7. /*
8.  * 拼接%
9.  */
10. 
11. public class ExcelPercentSuffixConvert implements Converter<Object> {
12. 
13. @Override
14. public WriteCellData<?> convertToExcelData(Object value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception {
15. if(value instanceof Double){
16. DecimalFormat decimalFormat = new DecimalFormat("###################.###########");
17.             value = decimalFormat.format(value);
18.         }
19. String cellData = value + "%";
20. return new WriteCellData<>(cellData);
21.     }
22. }