java开发教程-excel文件的读写

全栈工程师开发手册 （作者：栾鹏）

java教程全解

excel文件的读写，需要使用jxl包，使用示例。
jxl包下载
myfile.xls

import java.io.File; 
import java.util.*; 
import jxl.*;
import jxl.write.*; 

//本实例演示使用jxl包实现对excel文件的操作
public class MyExcel{

  //将数据写入excel文件
  public static void write_excel(String filepath,ArrayList<ArrayList<String>> data){
    try{
        //创建一个可写入的excel文件对象
        WritableWorkbook workbook = Workbook.createWorkbook(new File(filepath)); 
        //使用第一张工作表
        WritableSheet sheet = workbook.createSheet("工作表1", 0); 
        for (int i = 0; i < data.size(); i++) {
        	ArrayList<String> onerow=data.get(i);
			for (int j = 0; j < onerow.size(); j++) {
				String cell = onerow.get(j);
				Label label=new Label(j,i,data.get(i).get(j));
				sheet.addCell(label);
			}
		}
        
//        //格式化日期
//        jxl.write.DateFormat df = new jxl.write.DateFormat("yyyy-dd-MM  hh:mm:ss"); 
//        jxl.write.WritableCellFormat wcfDF = new jxl.write.WritableCellFormat(df); 
//        jxl.write.DateTime labelDTF = new jxl.write.DateTime(0, 1, new java.util.Date(), wcfDF); 
//        sheet.addCell(labelDTF);
//
//         //格式化数字
//        jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##"); 
//        WritableCellFormat wcfN = new WritableCellFormat(nf); 
//        jxl.write.Number labelNF = new jxl.write.Number(2, 1, 13.1415926, wcfN); 
//        sheet.addCell(labelNF); 
//        
        //关闭对象，释放资源
        workbook.write(); 
        workbook.close(); 

    }catch(Exception e){
      System.out.println(e);
    }
  }

  //读取excel数据
  public static ArrayList<ArrayList<String>> read_excel(String filepath) {
	ArrayList<ArrayList<String>> alldata=new ArrayList<ArrayList<String>>();
	Workbook workbook=null;
	try {
		workbook=Workbook.getWorkbook(new File(filepath));
		Sheet sheet=workbook.getSheet(0);  //使用第一个工作表
		int row=sheet.getRows();   
		int column=sheet.getColumns();  
		for (int i = 0; i < row; i++) {
			ArrayList<String> onerow=new ArrayList<String>();
			for (int j = 0; j < column; j++) {
				Cell a2=sheet.getCell(j, i);
				String rest=a2.getContents();
				if(rest!=null)
					onerow.add(rest);
			}
			alldata.add(onerow);
		}
	} catch (Exception e) {
		e.printStackTrace();
		if (workbook!=null) {
			workbook.close();
		}
	}
	return alldata;
  }
  
  
  
  public static void main(String[] arges){
      ArrayList<ArrayList<String>> alldata=read_excel("myfile.xls");
      for (ArrayList<String> arraylist:alldata) {
		for(String str:arraylist)
			System.out.println(str);
      }

      write_excel("myfile1.xls",alldata);
  }
   
}