資源簡介
將JTable中的數(shù)據(jù)導出到Excel文件。
代碼片段和文件信息
import?java.io.*;
import?javax.swing.JOptionPane;
import?javax.swing.JTable;
import?javax.swing.table.DefaultTableModel;
import?jxl.Workbook;
import?jxl.write.Number;
import?jxl.write.Label;
import?jxl.write.WritableSheet;
import?jxl.write.WritableWorkbook;
import?jxl.write.WriteException;
import?jxl.write.biff.RowsExceededException;
public?class?creatExcel?{
public?void?creatExcel(File?fileDefaultTableModel?tableModelJTable?jTable){
Label?labelS?=?null;
Number?labelN?=?null;
try{
FileOutputStream?os?=?new?FileOutputStream(file);
WritableWorkbook?wwb?=?Workbook.createWorkbook(os);
WritableSheet?ws?=?wwb.createSheet(“選擇題試題“0);
for(int?i?=?0;i
Label?label?=?new?Label(i0tableModel.getColumnName(i));
ws.addCell(label);
}
for(int?j?=0?;?j
for(int?i?=?0;i
if(jTab
評論
共有 條評論