大家好,在EXCEL导入数据后,部分代码如 :
InputStream isfile = new FileInputStream(paths);
jxl.Workbook rwb = Workbook.getWorkbook(isfile);
Sheet rsfile = rwb.getSheet(0);
String sheetnm = rsfile.getName();
col_count = rsfile.getColumns();
Cell c0 = rsfile.getCell(0,0);
i= c0.getContents();
Cell c1 = rsfile.getCell(1,0);
j = c1.getContents();
String sql="insert into a(q,w) " +"select "+i+","+j+" from " +
"OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=\""+path+"\";Extended " +"Properties=Excel 5.0')..."+sheetnm+"$ where "+serial+" is not null";
请问,我现想对j列里面的值进行判断是否为null,如果为null显示'-',否则显示原有值.请问这要怎样写?
InputStream isfile = new FileInputStream(paths);
jxl.Workbook rwb = Workbook.getWorkbook(isfile);
Sheet rsfile = rwb.getSheet(0);
String sheetnm = rsfile.getName();
col_count = rsfile.getColumns();
Cell c0 = rsfile.getCell(0,0);
i= c0.getContents();
Cell c1 = rsfile.getCell(1,0);
j = c1.getContents();
String sql="insert into a(q,w) " +"select "+i+","+j+" from " +
"OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=\""+path+"\";Extended " +"Properties=Excel 5.0')..."+sheetnm+"$ where "+serial+" is not null";
请问,我现想对j列里面的值进行判断是否为null,如果为null显示'-',否则显示原有值.请问这要怎样写?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货