java excel jxl 导出_Java导出成Excel的方法（需要jxl.jar包）

import java.io.File;

import java.sql.ResultSet;

import jxl.Workbook;

import jxl.write.Label;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import org.eclipse.swt.SWT;

import org.eclipse.swt.widgets.FileDialog;

import org.eclipse.swt.widgets.Shell;

public class Export2Excel {

public Export2Excel(Shell shell, String[] coloumNames, ResultSet rSet,

String sheetName) {

FileDialog fileDialog = new FileDialog(shell, SWT.NONE);

fileDialog.setFilterExtensions(new String[]{"*.xls"});

fileDialog.setText("文件另存为");

fileDialog.setFileName("temp.xls");

fileDialog.open();

String path = fileDialog.getFilterPath();

String fileName = fileDialog.getFileName();

try {

WritableWorkbook book = Workbook.createWorkbook((new File(path

+ "\\" + fileName)));

WritableSheet sheet = book.createSheet(sheetName, 0);

for (int i = 0; i < coloumNames.length; i++) {

sheet.setColumnView(100, 400);

Label label = new Label(i, 0, coloumNames[i]);

sheet.addCell(label);

}

int i = 0;

while (rSet.next()) {

i = i + 1;

Label label1A = new Label(0, i, rSet.getRow() + "");

sheet.addCell(label1A);

for (int j = 0; j < coloumNames.length; j++) {

System.out.println("j =" + j);

if (j == 0) {

Label label = new Label(j, i, rSet.getRow() + "");

sheet.addCell(label);

} else {

Label label = new Label(j, i, rSet.getString(j));

sheet.addCell(label);

}

}

}

book.write();

book.close();

} catch (Exception ex) {

ex.printStackTrace();

}

}

}

分享到：

2012-05-17 10:10

浏览 1467

评论