java 导出写入xls 代码记录

java 导出写入xls 代码记录

public static List<List<String>> readXLS(){
List<List<String>> result =new ArrayList<List<String>>();
try {
InputStream is=new FileInputStream(new File("c:\\test\\a.xls"));
HSSFWorkbook hssfworkbook=new HSSFWorkbook(is);
//获取文档sheet
for(int i=0;i<hssfworkbook.getNumberOfSheets();i++){
HSSFSheet hssfsheet=hssfworkbook.getSheetAt(i);
if(hssfsheet==null){
continue;
}
//获取sheet里面的行数据
for(int n=1;n<=hssfsheet.getLastRowNum();n++){
HSSFRow hssfRow=hssfsheet.getRow(n);
int min=hssfRow.getFirstCellNum();
int max=hssfRow.getLastCellNum();
List<String> rowList=new ArrayList<String>();

for(int m=min;m<=max;m++){
HSSFCell cell=hssfRow.getCell(m);
if(cell==null){
continue;
}
//System.out.println(Test.getStringVal(cell));
rowList.add(Test.getStringVal(cell));
}
}
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


return result;
}

//处理数据类型
public static String getStringVal(HSSFCell cell){
switch(cell.getCellType()){
case Cell.CELL_TYPE_BOOLEAN:
return cell.getBooleanCellValue()?"TRUE":"FALSE";
case Cell.CELL_TYPE_FORMULA:
return cell.getCellFormula();
case Cell.CELL_TYPE_NUMERIC:
cell.setCellType(Cell.CELL_TYPE_STRING);
return cell.getStringCellValue();
case Cell.CELL_TYPE_STRING:
return cell.getStringCellValue();
default:
return null;



}
}

public static void creatXls(){
HSSFWorkbook workbook=new HSSFWorkbook();
FileOutputStream fo=null;
try {
fo=new FileOutputStream(new File("c:\\test\\b.xls"));
HSSFSheet sheet1=workbook.createSheet("test");

HSSFPatriarch patriarch=sheet1.createDrawingPatriarch();

HSSFRow row=sheet1.createRow(0);
row.createCell(0).setCellValue("第一列");

HSSFClientAnchor anchor=new HSSFClientAnchor(0, 0, 0, 0, (short)14, 8, (short)6, 5);
HSSFTextbox testbox=patriarch.createTextbox(anchor);
testbox.setString(new HSSFRichTextString("测试"));

} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
workbook.write(fo);
fo.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}