Question

java JXL操作EXCEL创建文件后缀名为.xlsx的,也就是2007版本以上的

哪位大神帮忙解决下，最好有代码的

Answer 1

try{

SysCodeTemplateForm scpForm = (SysCodeTemplateForm) form;
FormFile formfile = scpForm.getUploadfile();
SysCodeTemplate scp = new SysCodeTemplate();
String reportfn = formfile.getFileName();
String savePath = "D:\\";
byte[] b = formfile.getFileData();
File file = new File(savePath);
if (!file.exists()) {
file.mkdirs();
}
File uploadFile = new File(file, reportfn);

FileOutputStream fops = new FileOutputStream(uploadFile);
fops.write(b);
fops.close();
XSSFWorkbook wookbook = new XSSFWorkbook(new FileInputStream(uploadFile));
XSSFSheet sheet = wookbook.getSheet("Sheet1");
int rows = sheet.getPhysicalNumberOfRows();
ArrayList<SysCodeTemplate> list1 = new ArrayList<SysCodeTemplate>();
ArrayList<SysCode> list2 = new ArrayList<SysCode>();
for (int i = 1; i < rows; i++) {
XSSFRow row = sheet.getRow(i);
if (row != null) {
int cells = row.getPhysicalNumberOfCells();
String value = "";
for (int j = 0; j < cells; j++) {
XSSFCell cell = row.getCell(j);
if (cell != null) {
switch (cell.getCellType()) {
case XSSFCell.CELL_TYPE_NUMERIC:
value += (long)cell.getNumericCellValue() + ",";
break;
case XSSFCell.CELL_TYPE_STRING:
value += cell.getStringCellValue() + ",";
break;
}
}
}
String valu = value.substring(0, value.length()-1);
String[] val = valu.split(",");
scp.setCodeCode(val[0]);
scp.setCodeName(val[1]);
scp.setCodeType(new Long(val[2]));
list1.add(scp);

}
}

追问

兄弟看不懂，能不能给个完整的例子

追答

http://www.cnblogs.com/bmbm/archive/2011/12/08/2342261.html 链接