如何把一个数据库内的一个表内容导入到excel文件中 sql oracle 可以直接导读表数据jxl poi写入excel 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 用pl/sql developer 工具,很方便的,直接查询这个表,再结果集中选择导出excel或者复制到excel。 直接在数据库上操作吗?有些是可以直接导入excel有些没xsl格式的,就先导成html的然后打开,右键,导入excel 如果你使用PLSQL,那么很简单,鼠标右键查询结果,会有一个“复制到Excel...”的选项,点击之后就会把数据复制到excel里面了,当然,前提是你的电脑安装了office 页面查询出导出吗?先把数据读取到LIST里,然后用XLS的API写如到XLS中即可下面是我以前写的一个简单的public ActionForward downxls(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { OutputStream out = null; try { out = response.getOutputStream(); response.setContentType("application/vnd.ms-excel"); String fileName = "导入xls文件模板.xls"; fileName = new String(fileName.getBytes("GB2312"), "ISO-8859-1"); response.setHeader("Content-Disposition", "attachment; filename=" + fileName); WritableWorkbook wwb = null; // Excel工作簿 WritableSheet ws = null; // ExcelSheet对象 String[] names = { "成员姓名", "成员号码", "成员生日" }; try { wwb = Workbook.createWorkbook(out); ws = wwb.createSheet("xls模板", 0); WritableCellFormat format = new WritableCellFormat(); WritableCellFormat dataFormat = new WritableCellFormat( WritableWorkbook.ARIAL_10_PT, NumberFormats.TEXT); int k = 1;// 表示行数 for (int i = 0; i < names.length; i++) { ws.addCell(new Label(i, 0, names[i], format)); } for (int i = 1; i <= 10; i++) { int j = 0; ws.addCell(new Label(j++, k, "姓名" + i, dataFormat)); ws.addCell(new Label(j++, k, "1391391391" + (i - 1), dataFormat)); ws.addCell(new Label(j++, k, "1980-1-1", dataFormat)); k++; } wwb.write(); wwb.close(); } catch (Exception e) { throw e; } finally { if (null != wwb) { wwb.close(); } } } catch (FileNotFoundException fe) { _log.error(fe.toString()); } catch (IOException ioe) { _log.error(ioe.toString()); } catch (Exception e) { _log.error(e.toString()); } finally { if (out != null) { try { out.close(); } catch (IOException e1) { _log.error(e1.toString()); } } } return null; } 两种方式 1\PLSQL直接查询导出2、JAVA程序,查询出结果,使用JXL来导出。 oracle 存放图片,jsp动态显示图片 json构建问题 Struts2中能为同一个action指定不同的方法吗? myeclipse里显示struct 求jpager的下载和使用方法 用jspsmartupload下载时的问题? jsp中 如何使用UBB? 急求"用户登录后长时间无操作,自动注销"的实现方法和代码 有用jsp实现blog开发的人吗 ant编译报错,怎么说包不存在啊 好久没来了,疯狂地啃书 jira连接oracle数据库时,出现:JIRA is unable to start ,the database has been locked?
下面是我以前写的一个简单的
public ActionForward downxls(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
{
OutputStream out = null;
try
{
out = response.getOutputStream();
response.setContentType("application/vnd.ms-excel");
String fileName = "导入xls文件模板.xls";
fileName = new String(fileName.getBytes("GB2312"), "ISO-8859-1");
response.setHeader("Content-Disposition", "attachment; filename="
+ fileName);
WritableWorkbook wwb = null; // Excel工作簿
WritableSheet ws = null; // ExcelSheet对象
String[] names = { "成员姓名", "成员号码", "成员生日" };
try
{
wwb = Workbook.createWorkbook(out);
ws = wwb.createSheet("xls模板", 0);
WritableCellFormat format = new WritableCellFormat();
WritableCellFormat dataFormat = new WritableCellFormat(
WritableWorkbook.ARIAL_10_PT, NumberFormats.TEXT);
int k = 1;// 表示行数
for (int i = 0; i < names.length; i++)
{
ws.addCell(new Label(i, 0, names[i], format));
}
for (int i = 1; i <= 10; i++)
{
int j = 0;
ws.addCell(new Label(j++, k, "姓名" + i, dataFormat));
ws.addCell(new Label(j++, k, "1391391391" + (i - 1),
dataFormat));
ws.addCell(new Label(j++, k, "1980-1-1", dataFormat));
k++;
}
wwb.write();
wwb.close();
}
catch (Exception e)
{
throw e;
}
finally
{
if (null != wwb)
{
wwb.close();
}
}
}
catch (FileNotFoundException fe)
{
_log.error(fe.toString());
}
catch (IOException ioe)
{
_log.error(ioe.toString());
}
catch (Exception e)
{
_log.error(e.toString());
}
finally
{
if (out != null)
{
try
{
out.close();
}
catch (IOException e1)
{
_log.error(e1.toString());
}
}
}
return null;
}
2、JAVA程序,查询出结果,使用JXL来导出。