åèä¸é¢ä»£ç ï¼
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
public class WriteExcel {
WritableWorkbook book=null;
public void OutputExcel(ArrayList arlist,String Path){
try{
book = Workbook.createWorkbook(new File(Path));
//设置表å
WritableSheet sheet = book.createSheet("èè¯å",0);
//çæè¡¨æ ¼é¢å¤´
Label labe1 = new Label(0, 0, "èçå§å" );
Label labe2 = new Label(1, 0, "å°åº");
Label labe3 = new Label(2, 0, "æå±é¢æ ¡");
Label labe4 = new Label(3, 0, "ç级");
Label labe5 = new Label(4, 0, "èè¯å·");
Label labe6 = new Label(5, 0, "èè¯æ¶é´");
Label labe7 = new Label(6, 0, "ç§ç®å称");
//å°çæçåå
æ ¼æ·»å å°å·¥ä½è¡¨ä¸
sheet.addCell(labe1);
sheet.addCell(labe2);
sheet.addCell(labe3);
sheet.addCell(labe4);
sheet.addCell(labe5);
sheet.addCell(labe6);
sheet.addCell(labe7);
Iterator it = arlist.iterator();
int i = 1;
while(it.hasNext()){
//éè¿è¿ä»£è·å¾arlistéçMarkesData对象
MarkesData temp = (MarkesData)it.next();
//åå¾æ°æ®çæåå
æ ¼
Label label1=new Label(0,i,temp.getUser_name());
Label label2=new Label(1,i,temp.getArea_name());
Label label3=new Label(2,i,temp.getCollege_name());
Label label4=new Label(3,i,temp.getClass_name());
Label label5=new Label(4,i,temp.getTest_name());
Label label6=new Label(5,i,temp.getStarttime());
Label label7=new Label(6,i,temp.getSubject_name());
//å°çæçåå
æ ¼æ·»å å°å·¥ä½è¡¨ä¸
sheet.addCell(label1);
sheet.addCell(label2);
sheet.addCell(label3);
sheet.addCell(label4);
sheet.addCell(label5);
sheet.addCell(label6);
sheet.addCell(label7);
i++;
}
book.write();
book.close();
} catch (RowsExceededException e) {
e.printStackTrace();
} catch (WriteException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally{
try{
if(book!=null)book.close();
}catch(Exception e){
System.out.println("exception when closing Connection in finally");
System.out.println(e.getMessage().toString());
}
}
}
}
温馨提示:答案为网友推荐,仅供参考