随笔分类 - jxl操作excel
摘要：之前并没有做过编码控制,汉字也不会出现问题,唯独某些特殊符号会出乱子!
阅读全文
摘要：excel中同表格换行: a+"\n"+b 1.读取 String str = sheet.getCell(c, r).getContents(); String[] split = str.split("\n");//根据换行符截取 2.添加 sheet.addCell(new jxl.write
阅读全文
摘要：Range[] rangeCells = sheet.getMergedCells();// 返回sheet中合并的单元格数组 for (Range r : rangeCells) {//对数组遍历拿到每个合并的单元格 Cell cellTop = r.getTopLeft();//获取某个合并的单
阅读全文
摘要：String path=""; String path2=""; File file = new File(path); File file2 = new File(path2); 1.Workbook wb = jxl.Workbook.getWorkbook(file);//读取excel,这个
阅读全文
摘要：错误位置： File file= new File("/report/_test/test.xls");Workbook wb1 = jxl.Workbook.getWorkbook(file); 报的错误是：The input file was not found ，如果是路径不对导致没找到这个文
阅读全文
