Java开发网 Java开发网
注册 | 登录 | 帮助 | 搜索 | 排行榜 | 发帖统计  

您没有登录

» Java开发网 » Java SE 综合讨论区  

按打印兼容模式打印这个话题 打印话题    把这个话题寄给朋友 寄给朋友    该主题的所有更新都将Email到你的邮箱 订阅主题
flat modethreaded modego to previous topicgo to next topicgo to back
作者 Re:请教(jExcelAPI) [Re:zero0]
zero0





发贴: 28
积分: 0
于 2004-10-25 11:49 user profilesend a private message to usersearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
谢谢大家
{请活用您的编辑功能,教大的错误信息请用TXT文件上传,以便减少对文章易读性的影响}
源代码简单如下:
try 
{

//构建Workbook对象, 只读Workbook对象
//Method 1:创建可写入的Excel工作薄
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(new File(filename));
//Method 2:将WritableWorkbook直接写入到输出流
/*
OutputStream os = new FileOutputStream(targetfile);
jxl.write.WritableWorkbook wwb = Workbook.createWorkbook(os);
*/
//创建Excel工作表
jxl.write.WritableSheet ws = wwb.createSheet("指标数据统计", 0);
//
jxl.write.Label labelC0 = new jxl.write.Label(0, 0, "序号");
jxl.write.Label labelC1 = new jxl.write.Label(1, 0, "日期");
jxl.write.Label labelC2 = new jxl.write.Label(2, 0, "会议次数");
jxl.write.Label labelC3 = new jxl.write.Label(3, 0, "最大会议时长");
jxl.write.Label labelC4 = new jxl.write.Label(4, 0, "集群注册人数");

ws.addCell(labelC0);
ws.addCell(labelC1);
ws.addCell(labelC2);
ws.addCell(labelC3);
ws.addCell(labelC4);

rs = cst.executeQuery();
while (rs.next())
{
temp_row ++;
int hy_ct = rs.getInt("hy_ct");
int MAXSC = rs.getInt("MAXSC");
int JQC = rs.getInt("JQC");
String dt = rs.getString("dt").trim();
int maxsc_h = MAXSC / 3600;
int maxsc_m = (MAXSC % 3600)/60;
int maxsc_s = MAXSC % 60;
String s_maxsc = Integer.toString(maxsc_h)+":"+Integer.toString(maxsc_m)+":"+Integer.toString(maxsc_s);

jxl.write.Number labelN0 = new jxl.write.Number(0, temp_row, temp_row);
jxl.write.Label labelN1 = new jxl.write.Label(1, temp_row, dt);
jxl.write.Number labelN2 = new jxl.write.Number(2, temp_row, hy_ct);
jxl.write.Label labelN3 = new jxl.write.Label(3, temp_row, s_maxsc);
jxl.write.Number labelN4 = new jxl.write.Number(4, temp_row, JQC);

ws.addCell(labelN0);
ws.addCell(labelN1);
ws.addCell(labelN2);
ws.addCell(labelN3);
ws.addCell(labelN4);

}
//写入Excel对象
wwb.write();
//关闭可写入的Excel对象
wwb.close();
}
catch (Exception e)
{
e.printStackTrace();
}

在windows环境下运行正常

但移植到linux下后会出现如下错误:

error.txt (8.57k)


littledeer1974 edited on 2004-10-29 14:39


话题树型展开
人气 标题 作者 字数 发贴时间
9113 请教(jExcelAPI) zero0 110 2004-10-21 14:52
8100 Re:请教(jExcelAPI) kavinwang 57 2004-10-21 18:52
7974 Re:请教(jExcelAPI) Benny139 119 2004-10-26 23:37
7932 Re:请教(jExcelAPI) zero0 14 2004-10-27 11:45
7947 Re:请教(jExcelAPI) kavinwang 66 2004-10-27 12:42
9103 Re:请教(jExcelAPI) littledeer1974 2909 2004-11-01 16:52
7832 Re:请教(jExcelAPI) kavinwang 39 2004-11-01 20:59
7995 Re:请教(jExcelAPI) zero0 204 2004-11-04 10:55
8049 Re:请教(jExcelAPI) zero0 146 2004-10-22 11:04
8042 Re:请教(jExcelAPI) kavinwang 44 2004-10-22 13:05
7908 Re:请教(jExcelAPI) zero0 2557 2004-10-25 11:49
7973 Re:请教(jExcelAPI) zero0 58 2004-10-25 11:51
7895 Re:请教(jExcelAPI) littledeer1974 2109 2004-10-26 08:12
7860 Re:请教(jExcelAPI) archonLing 255 2004-10-26 09:02
7982 Re:请教(jExcelAPI) zero0 113 2004-10-26 09:17
7970 Re:请教(jExcelAPI) zero0 98 2004-10-26 09:23

flat modethreaded modego to previous topicgo to next topicgo to back
  已读帖子
  新的帖子
  被删除的帖子
Jump to the top of page

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923