jexcel处理样式的例子有没有? http://www-900.ibm.com/developerWorks/cn/java/l-javaExcel/index.shtml 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 -----------包import jxl.Workbook;import jxl.write.Label;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;-----------测试函数 protected static void TestJxl(int s) { try { WritableWorkbook wbook = null; WritableSheet wsheet = null; Label label = null; InputStream fis = new FileInputStream(new File("C:\\DzxhFile\\excel.xls")); Workbook wb = Workbook.getWorkbook(fis); OutputStream fos = new FileOutputStream(new File("C:\\DzxhFile\\excel.xls")); wbook = Workbook.createWorkbook(fos,wb); if(wbook.getNumberOfSheets()==0){ wsheet = wbook.createSheet("Sheet0", 0); }else{ wsheet = wbook.getSheet(0); } for (int i = s; i < 5000+s; i++) { label = new Label(0,i,"0-"+i); wsheet.addCell(label); label = new Label(1,i,"1-"+i); wsheet.addCell(label); label = new Label(2,i,"2-"+i); wsheet.addCell(label); label = new Label(3,i,"3-"+i); wsheet.addCell(label); label = new Label(4,i,"4-"+i); wsheet.addCell(label); label = new Label(5,i,"5-"+i); wsheet.addCell(label); label = new Label(6,i,"6-"+i); wsheet.addCell(label); label = new Label(7,i,"7-"+i); wsheet.addCell(label); label = new Label(8,i,"8-"+i); wsheet.addCell(label); label = new Label(9,i,"9-"+i); wsheet.addCell(label); label = new Label(10,i,"10-"+i); wsheet.addCell(label); label = new Label(11,i,"11-"+i); wsheet.addCell(label); label = new Label(12,i,"12-"+i); wsheet.addCell(label); label = new Label(13,i,"13-"+i); wsheet.addCell(label); label = new Label(14,i,"14-"+i); wsheet.addCell(label); } wbook.write(); wbook.close(); fos.flush(); fos.close(); fis.close(); wb.close(); } catch (Exception e) { e.printStackTrace(); return; }} spring3 mvc进行表单校验时,使用annotation-driven后,@ResponseBody乱码问题 关于ice的并发问题 hibernate关联查询的问题 jsp如何定时更新数据 html标签中的id 和 name 究竟有什么区别呀 ext中怎么动态设置form表单为readonly和可编辑 关于搜索信息和数据导入的问题!(求救!!!) jsp连SQL SERVER 有哪几种方式?怎么接啊? jsp下怎样连接PostgreSQL数据库, 请问谁知道哪有免费的jsp空间,最好带数据库支持的,谢谢 高手请帮忙 ireport使用问题
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;-----------测试函数
protected static void TestJxl(int s) {
try {
WritableWorkbook wbook = null;
WritableSheet wsheet = null;
Label label = null;
InputStream fis = new FileInputStream(new File("C:\\DzxhFile\\excel.xls"));
Workbook wb = Workbook.getWorkbook(fis);
OutputStream fos = new FileOutputStream(new File("C:\\DzxhFile\\excel.xls"));
wbook = Workbook.createWorkbook(fos,wb);
if(wbook.getNumberOfSheets()==0){
wsheet = wbook.createSheet("Sheet0", 0);
}else{
wsheet = wbook.getSheet(0);
} for (int i = s; i < 5000+s; i++) { label = new Label(0,i,"0-"+i);
wsheet.addCell(label);
label = new Label(1,i,"1-"+i);
wsheet.addCell(label);
label = new Label(2,i,"2-"+i);
wsheet.addCell(label);
label = new Label(3,i,"3-"+i);
wsheet.addCell(label);
label = new Label(4,i,"4-"+i);
wsheet.addCell(label);
label = new Label(5,i,"5-"+i);
wsheet.addCell(label);
label = new Label(6,i,"6-"+i);
wsheet.addCell(label);
label = new Label(7,i,"7-"+i);
wsheet.addCell(label);
label = new Label(8,i,"8-"+i);
wsheet.addCell(label);
label = new Label(9,i,"9-"+i);
wsheet.addCell(label);
label = new Label(10,i,"10-"+i);
wsheet.addCell(label);
label = new Label(11,i,"11-"+i);
wsheet.addCell(label);
label = new Label(12,i,"12-"+i);
wsheet.addCell(label);
label = new Label(13,i,"13-"+i);
wsheet.addCell(label);
label = new Label(14,i,"14-"+i);
wsheet.addCell(label);
}
wbook.write();
wbook.close();
fos.flush();
fos.close();
fis.close();
wb.close();
}
catch (Exception e) {
e.printStackTrace();
return;
}
}