//下面这段代码是将内容写入一个excel文档//----------------------------------------------------------------------package Print;import java.util.StringTokenizer;import jxl.*;import jxl.write.*;import jxl.format.*;import java.io.*;import java.sql.*;import conn.*;import TypeChare.*;public class writeexcel{ WritableSheet sheet; File tempFile; WritableWorkbook workbook; WritableFont headerFont; WritableFont titleFont; WritableFont detFont; WritableCellFormat titleFormat; WritableCellFormat headerFormat; WritableCellFormat detFormat; WritableCellFormat priceFormat; WritableCellFormat dateFormat; Label l=null; jxl.write.Number n=null; jxl.write.DateTime d=null; int column=0;//================== 打开EXCEL文件 ============================= public writeexcel(String OutFile){ try{ tempFile=new File(OutFile); workbook = Workbook.createWorkbook(tempFile); sheet = workbook.createSheet("用户", 0); headerFont = new WritableFont(WritableFont.ARIAL, 12, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); headerFormat = new WritableCellFormat (headerFont); titleFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); titleFormat = new WritableCellFormat (titleFont); detFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.NO_BOLD, false, UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK); detFormat = new WritableCellFormat (detFont); NumberFormat nf=new NumberFormat("0.00"); //用于Number的格式 priceFormat = new WritableCellFormat (detFont, nf); DateFormat df=new DateFormat("yyyy-MM-dd");//用于日期的 dateFormat = new WritableCellFormat (detFont, df); //合并第一列第一行到第六列第一行的所有单元格 sheet.mergeCells(0,0,5,0); //单元格边框设置 headerFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.MEDIUM); titleFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN); detFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN); priceFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN); dateFormat.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN); //单元格文字位置设置 headerFormat.setAlignment(jxl.format.Alignment.CENTRE); } catch(Exception e) { System.out.println("error0:"+e.getMessage()); } }//======================= 显示表头 ================================public boolean setColumTitle(String Columtitle) { //表头 try{ l=new Label(0, 0, Columtitle, headerFormat); sheet.addCell(l); } catch(Exception e) { System.out.println("error1:"+e.getMessage()); } return true; }//======================= 显示表内容 =============================public boolean DisplayDetail(String sql) { try{ int h=0; conn conn= new conn(); ResultSet Rs=conn.executeQuery(sql); column=0; for (int i=1; i<=Rs.getMetaData().getColumnCount(); i++){ l=new Label(column++, 2, Rs.getMetaData().getColumnName(i), titleFormat); //sheet.setColumnView(column,Rs.getString(i).length()); //System.out.println(Rs.getMetaData().getColumnDisplaySize(i)); sheet.addCell(l);} while (Rs.next()){ column=0; for (int j=1; j<=Rs.getMetaData().getColumnCount(); j++){ if (Rs.getMetaData().getColumnTypeName(j).compareTo("VARCHAR2")==0) l=new Label(column++, h+3, Rs.getString(j),detFormat); if (Rs.getMetaData().getColumnTypeName(j).compareTo("NUMBER")==0) l=new Label(column++, h+3, Rs.getString(j),priceFormat); if (Rs.getMetaData().getColumnTypeName(j).compareTo("DATE")==0) l=new Label(column++, h+3, Rs.getString(j),dateFormat); sheet.addCell(l); } h++; } Rs=null; conn.close(); //设置列的宽度 //column=0; //sheet.setColumnView(column++, 10); //sheet.setColumnView(column++, 10); //sheet.setColumnView(column++, 10); //sheet.setColumnView(column++, 10); workbook.write(); workbook.close(); } catch(Exception e) { System.out.println("error1:"+e.getMessage()); } return true; } public static void main(String args[]) { // new writeexcel("d:/Print.xls"); } }
excel 写入 oracle,oracle 写入excel
最新推荐文章于 2022-11-01 15:48:56 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)