如果通过单击按扭生成文件? 我想在网页上单击按扭,就会把刚才从数据库查询到的数据导入到excel里面去,请问这怎么实现? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看看下面这段程序:public static HSSFWorkbook highlightExcel_view(Vector tmpVector, String excel_flag) throws Exception { String empno=""; String user_id=""; String full_name=""; String app_id=""; String excel_subject = ""; HSSFWorkbook wb = new HSSFWorkbook(); if("terminate".equals(excel_flag)) excel_subject = "Terminate User List"; HSSFSheet sheet1 = wb.createSheet(excel_subject); HSSFRow row = null; HSSFCell cell = null; HSSFCellStyle cellBorderBoldStyle= wb.createCellStyle(); HSSFCellStyle cellBoldStyle= wb.createCellStyle(); HSSFCellStyle cellBorderStyle= wb.createCellStyle(); HSSFCellStyle cellStyle= wb.createCellStyle(); HSSFFont boldFont = wb.createFont(); HSSFFont font = wb.createFont(); boldFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD); cellBoldStyle.setFont(boldFont); cellBorderStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN); cellBorderStyle.setBottomBorderColor(HSSFColor.BLACK.index); cellBorderStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN); cellBorderStyle.setLeftBorderColor(HSSFColor.BLACK.index); cellBorderStyle.setBorderRight(HSSFCellStyle.BORDER_THIN); cellBorderStyle.setRightBorderColor(HSSFColor.BLACK.index); cellBorderStyle.setBorderTop(HSSFCellStyle.BORDER_THIN); cellBorderStyle.setTopBorderColor(HSSFColor.BLACK.index); // start writing on sheet 1 (transfer in ) // row 0 row = sheet1.createRow((short)0); if("terminate".equals(excel_flag)){ cell = FieldData.createStringCell(row, 0, "Terminate User Account List", cellBoldStyle); // row1 row = sheet1.createRow((short)1); cell = FieldData.createStringCell(row, 0, "Emp NO.", cellBoldStyle); cell = FieldData.createStringCell(row, 1, "Full Name", cellBoldStyle); cell = FieldData.createStringCell(row, 2, "Terminate Date", cellBoldStyle); cell = FieldData.createStringCell(row, 3, "User Id", cellBoldStyle); cell = FieldData.createStringCell(row, 4, "Appcation", cellBoldStyle); } sheet1.addMergedRegion(new Region(0,(short)0, 0,(short)0)); for(int j=0;j<tmpVector.size();j++){ row = sheet1.createRow((short)(j+2)); for(int k=0; k < ((Vector)tmpVector.get(j)).size()-3; k++) cell = FieldData.createStringCell(row, k,((Vector)tmpVector.get(j)).get(k).toString(), cellBorderStyle); sheet1.addMergedRegion(new Region(0,(short)0, 0,(short)2)); } return wb; } 楼上的你给的是一个写excel的例子吗?我想知道在查询到数据后,比如在数据列表的旁边有一个按扭“导出到excel”,然后单击这个按扭就可以在客户机上生成一个xls文件 这个你得找有第三方jar包基本上都有例子的比较简单"利用JAVA操作EXCEL文件(JAVA EXCEL API)"http://www.88doc.com/88doc/software/java/2/2_1168879968090.html 写个ActiveX控件,调用其方法,把文件生成在IE的零食目录下面,生成完后打开它 我不会ActiveX-_-!!有用jsp或者js的解决方法没有? 我不明白,你既然要去后台DB中查数据,那又为什么非要在客户端生成excel档呢? ExcelApp = new ActiveXObject("Excel.Application"); ExcelApp.DisplayAlerts = false; ExcelWorkbooks = ExcelApp.Workbooks; ExcelWorkbooks.open("....:\\tmp.xls"); ExcelWorkbooks("tmp.xls").Activate; ExcelApp.Sheets(1).Name = "tttt"; ActiveSheet = ExcelWorkbooks("tmp.xls").Sheets(1); ActiveSheet.Name = "sheet name"; alert(ExcelApp.Sheets(1).Cells(1, 1).Value , 0 , "cell value"); 比如客户查到数据后,想把数据导到xls里面保存起来啊 http://dev.csdn.net/article/75/75272.shtm需要引入jxl.jar包 谢谢楼上的。我想知道的是怎么单击按钮后可以在正在浏览网页的客户机上导出包括刚查询到的数据的xls文件 没那么麻烦的,告诉你个很简单的方法,你做一个和你这个页一样的页,在最上面引用的那里加入下面这段话,看效果吧,你会满意的<% response.setContentType("application/vnd.ms-excel;charset=GBK"); %> struts2 exception java.lang.NoClassDefFoundError: javax/sql/rowset/Joinable JSP可以做趋势图 谁给我个站内搜索的方案?? 敏捷之源JAVA开源项目大全速查下载(送分) 多表连接查询的速度问题 用什么办法用脚本来控制页边距和页眉,页脚,高分求. 请大家帮忙看一下TOMCAT的问题! 请问现在深入学习servlet还有没有必要 请问jsp中page指令的import 属性的写法? 下拉框动态对应问题 TOMCAT的多线程下载控制怎么做??
public static HSSFWorkbook highlightExcel_view(Vector tmpVector, String excel_flag) throws Exception {
String empno="";
String user_id="";
String full_name="";
String app_id="";
String excel_subject = ""; HSSFWorkbook wb = new HSSFWorkbook();
if("terminate".equals(excel_flag))
excel_subject = "Terminate User List";
HSSFSheet sheet1 = wb.createSheet(excel_subject);
HSSFRow row = null;
HSSFCell cell = null;
HSSFCellStyle cellBorderBoldStyle= wb.createCellStyle();
HSSFCellStyle cellBoldStyle= wb.createCellStyle();
HSSFCellStyle cellBorderStyle= wb.createCellStyle();
HSSFCellStyle cellStyle= wb.createCellStyle();
HSSFFont boldFont = wb.createFont();
HSSFFont font = wb.createFont(); boldFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
cellBoldStyle.setFont(boldFont); cellBorderStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
cellBorderStyle.setBottomBorderColor(HSSFColor.BLACK.index);
cellBorderStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
cellBorderStyle.setLeftBorderColor(HSSFColor.BLACK.index);
cellBorderStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
cellBorderStyle.setRightBorderColor(HSSFColor.BLACK.index);
cellBorderStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
cellBorderStyle.setTopBorderColor(HSSFColor.BLACK.index); // start writing on sheet 1 (transfer in )
// row 0
row = sheet1.createRow((short)0);
if("terminate".equals(excel_flag)){
cell = FieldData.createStringCell(row, 0, "Terminate User Account List", cellBoldStyle);
// row1
row = sheet1.createRow((short)1);
cell = FieldData.createStringCell(row, 0, "Emp NO.", cellBoldStyle);
cell = FieldData.createStringCell(row, 1, "Full Name", cellBoldStyle);
cell = FieldData.createStringCell(row, 2, "Terminate Date", cellBoldStyle);
cell = FieldData.createStringCell(row, 3, "User Id", cellBoldStyle);
cell = FieldData.createStringCell(row, 4, "Appcation", cellBoldStyle);
}
sheet1.addMergedRegion(new Region(0,(short)0, 0,(short)0));
for(int j=0;j<tmpVector.size();j++){
row = sheet1.createRow((short)(j+2));
for(int k=0; k < ((Vector)tmpVector.get(j)).size()-3; k++)
cell = FieldData.createStringCell(row, k,((Vector)tmpVector.get(j)).get(k).toString(), cellBorderStyle);
sheet1.addMergedRegion(new Region(0,(short)0, 0,(short)2));
}
return wb;
}
我想知道在查询到数据后,比如在数据列表的旁边有一个按扭“导出到excel”,然后单击这个按扭就可以在客户机上生成一个xls文件
基本上都有例子的
比较简单
"利用JAVA操作EXCEL文件(JAVA EXCEL API)"
http://www.88doc.com/88doc/software/java/2/2_1168879968090.html
有用jsp或者js的解决方法没有?
ExcelApp = new ActiveXObject("Excel.Application");
ExcelApp.DisplayAlerts = false;
ExcelWorkbooks = ExcelApp.Workbooks;
ExcelWorkbooks.open("....:\\tmp.xls");
ExcelWorkbooks("tmp.xls").Activate;
ExcelApp.Sheets(1).Name = "tttt";
ActiveSheet = ExcelWorkbooks("tmp.xls").Sheets(1);
ActiveSheet.Name = "sheet name";
alert(ExcelApp.Sheets(1).Cells(1, 1).Value , 0 , "cell value");
<% response.setContentType("application/vnd.ms-excel;charset=GBK"); %>