转换报错

报错堆栈信息：
java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Short
	at org.ttzero.excel.entity.ICellValueAndStyle.setCellValue(ICellValueAndStyle.java:142)
	at org.ttzero.excel.entity.ICellValueAndStyle.reset(ICellValueAndStyle.java:64)
	at org.ttzero.excel.entity.ResultSetSheet.resetBlockData(ResultSetSheet.java:281)
	at org.ttzero.excel.entity.Sheet.nextBlock(Sheet.java:1166)
	at org.ttzero.excel.entity.e7.XMLWorksheetWriter.writeTo(XMLWorksheetWriter.java:226)
	at org.ttzero.excel.entity.Sheet.writeTo(Sheet.java:965)
	at org.ttzero.excel.entity.e7.XMLWorkbookWriter.createTemp(XMLWorkbookWriter.java:387)
	at org.ttzero.excel.entity.e7.XMLWorkbookWriter.writeTo(XMLWorkbookWriter.java:130)
	at org.ttzero.excel.entity.Workbook.writeTo(Workbook.java:705)
1、源码
 Class.forName("org.apache.hive.jdbc.HiveDriver");
Connection conn = DriverManager.getConnection(url,user,password);
 Statement stat = conn.createStatement();
String hiveSql = "select * from table";
ResultSet rs = stat.executeQuery(hiveSql);
File file = new File("D:\\11.xlsx");
Workbook workbook = new Workbook();
workbook.addSheet(new ResultSetSheet(rs));
workbook.writeTo(file);
2、表的字段类型如下
tinyint、smallint、int、bigint、float、double、string、varchar(100)、char(100)、date、timestamp、string

wangguanquan/eec

内容风险标识

评论 (8)

wangguanquan/eec .gitee-modal { width: 500px !important; }

内容风险标识

转换报错

评论 (8)

搜索帮助

wangguanquan/eec