import java.io.*;
import java.io.File.*;
import java.util.*;
import javax.swing.JFileChooser;
import javax.swing.filechooser.FileFilter;
import javax.swing.filechooser.FileNameExtensionFilter;
import jxl.Workbook;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class WriteToXML {
public static void main(String[] args) {
File file=null;
JFileChooser dlg=new JFileChooser();
dlg.setDialogTitle("save Excel file");
FileFilter filter=new FileNameExtensionFilter("Excel File(*.xls)","xls");
dlg.setFileFilter(filter);
int result = dlg.showSaveDialog(dlg);
if (result == JFileChooser.APPROVE_OPTION) {
file= dlg.getSelectedFile();
}
System.out.println(file.getAbsolutePath());
writeExcel(file.getAbsolutePath());
}
public static void writeExcel(String filePath) {
try {
// 创建工作薄
WritableWorkbook wwb = Workbook.createWorkbook(new File(filePath));
// 创建工作表
WritableSheet ws = wwb.createSheet("Sheet1", 0);
// System.out.println("create ok!");
// 添加标签文本
Random rnd = new Random((new Date()).getTime());
int forNumber = rnd.nextInt(100);
for (int i = 0; i < forNumber; i++) {
ws.addCell(new jxl.write.Number(rnd.nextInt(50), rnd
.nextInt(50), rnd.nextInt(1000)));
}
// 添加图片(注意此处jxl暂时只支持png格式的图片)
// 0,1分别代表x,y 2,5代表宽和高占的单元格数
//ws.addImage(new jxl.write.WritableImage(0, 1, 2, 5, new File("E://picture//logo_cn.gif")));
wwb.write();
wwb.close();
} catch (Exception e) {
System.out.println(e.toString());
}
}
}