jxl操作EXCEL

最新推荐文章于 2024-05-03 10:30:24 发布
最新推荐文章于 2024-05-03 10:30:24 发布
阅读量754 收藏
点赞数
文章标签： null import string excel file sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/heyongbing02/article/details/2280914
版权
/*
 * NewJPanel.java
 *
 * Created on 2008年1月24日, 上午 10:51
 */

package  hsf;

 import  java.io.File;
 import  java.io.FileOutputStream;
 import  java.io.IOException;
 import  java.sql.Connection;
 import  java.sql.ResultSet;
 import  java.sql.Statement;
 import  javax.swing.JFileChooser;
 import  javax.swing.JFrame;
 import  javax.swing.JOptionPane;
 import  jxl.CellType;
 import  jxl.Sheet;
 import  jxl.Workbook;
 import  jxl.format.CellFormat;
 import  jxl.read.biff.BiffException;
 import  jxl.write.Border;
 import  jxl.write.BorderLineStyle;
 import  jxl.write.Label;
 import  jxl.write.WritableCell;
 import  jxl.write.WritableCellFormat;
 import  jxl.write.WriteException;

 /**
 *
 * @author  joelhe
 */
public   class  NewJPanel  extends  javax.swing.JPanel  {
    
    /** Creates new form NewJPanel */
    JFrame j=null;
    Dbcon con=new Dbcon();
    public NewJPanel(JFrame j) {
        initComponents();
        this.j=j;
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" 建置的代碼 ">                          
    private void initComponents() {
        jLabel1 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jLabel3 = new javax.swing.JLabel();
        jTextField2 = new javax.swing.JTextField();
        jButton3 = new javax.swing.JButton();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();

        jLabel1.setFont(new java.awt.Font("新細明體", 1, 24));
        jLabel1.setText("ROHS檢驗報告");

        jTable1.setFont(new java.awt.Font("新細明體", 0, 16));
        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null, null, null, null, null, null}
            },
            new String [] {
                "MISC", "LINE", "SAMPLE", "TIME", "LOCATION", "Cd", "Pb", "Hg", "Cr", "Br", "RESULT", "INSPECT"
            }
        ));
        jScrollPane1.setViewportView(jTable1);

        jLabel3.setFont(new java.awt.Font("新細明體", 0, 16));
        jLabel3.setText("MISC:");

        jTextField2.setFont(new java.awt.Font("新細明體", 0, 16));

        jButton3.setText("查詢");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });

        jButton1.setText("jButton1");

        jButton2.setText("導出EXCEL");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(this);
        this.setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 692, Short.MAX_VALUE)
            .addGroup(layout.createSequentialGroup()
                .addGap(169, 169, 169)
                .addComponent(jLabel3, javax.swing.GroupLayout.PREFERRED_SIZE, 49, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 183, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jButton3)
                .addGap(101, 101, 101)
                .addComponent(jButton2)
                .addContainerGap(30, Short.MAX_VALUE))
            .addGroup(layout.createSequentialGroup()
                .addGap(229, 229, 229)
                .addComponent(jLabel1)
                .addContainerGap(299, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(45, 45, 45)
                .addComponent(jLabel1)
                .addGap(28, 28, 28)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 121, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(32, 32, 32)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel3)
                    .addComponent(jButton3)
                    .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jButton2))
                .addContainerGap(75, Short.MAX_VALUE))
        );
    }// </editor-fold>                        

    public void addcell(jxl.write.WritableSheet wws,int m,String a,String b,String c,String d,String e,String f){
        try {
            WritableCellFormat format = new  WritableCellFormat();
            format.setBorder(Border.ALL,BorderLineStyle.MEDIUM);
            wws.addCell(new jxl.write.Label(3,m,a,format));
            wws.addCell(new jxl.write.Label(4,m,b,format));
            wws.addCell(new jxl.write.Label(5,m,c,format));
            wws.addCell(new jxl.write.Label(6,m,d,format));
            wws.addCell(new jxl.write.Label(8,m,e,format));
            wws.addCell(new jxl.write.Label(9,m,f,format));
        } catch (WriteException ex) {
            ex.printStackTrace();
        }
    }

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        try {
            JFileChooser jFileChoose=new javax.swing.JFileChooser();
            FileOutputStream fos;
            String cell1="";
            String cell2="";
            String cell3="";
            String cell4="";
            String cell5="";
            String tempmisc="";
            String templocation="";
            String tempCd="";
            String tempPb="";
            String tempHg="";
            String tempCr="";
            String tempBr="";
            String tempResult="";
            WritableCellFormat format = new  WritableCellFormat();
            format.setBorder(Border.ALL,BorderLineStyle.MEDIUM);
            jFileChoose.showSaveDialog(null);
            File file=jFileChoose.getSelectedFile();
            fos=new FileOutputStream(file+".xls");
            Workbook rw;
            rw = Workbook.getWorkbook(new File("HSF.xls"));
            jxl.write.WritableWorkbook wb=Workbook.createWorkbook(fos,rw);
            jxl.write.WritableSheet ws=wb.getSheet(0);
            cell1=(String) jTable1.getValueAt(0,0);
            if(cell1==null){
                cell1="";
            }
            System.out.println(cell1);
            for(int k=0;k<5;k++){
                cell2=(String) jTable1.getValueAt(k,1);
                if(cell2==null){
                    cell2="";
                }else if(cell2.trim().equals("")){
                }else{
                    break;
                }
            }
            for(int k=0;k<5;k++){
                cell3=(String) jTable1.getValueAt(k,2);
                if(cell3==null){
                    cell3="";
                }else if(cell3.trim().equals("")){
                }else{
                    break;
                }
            }
            cell4=(String) jTable1.getValueAt(0,3);
            if(cell4==null){
                cell4="";
            }
            cell5=(String) jTable1.getValueAt(0,11);
            if(cell5==null){
                cell5="";
            }           
                System.out.println(jTable1.getValueAt(k,4).toString());
                if(jTable1.getValueAt(k,4).toString().trim().indexOf("14")!=-1){
//            try {
                ws.addCell(new jxl.write.Label(9,2,cell4));
                ws.addCell(new jxl.write.Label(2,3,cell2,format));
                ws.addCell(new jxl.write.Label(7,3,cell3,format));
                ws.addCell(new jxl.write.Label(7,4,cell1,format));
                ws.addCell(new jxl.write.Label(1,36,cell5));
//            } catch (WriteException ex) {
//                ex.printStackTrace();
//            }
            for(int n=0;n<5;n++){
                tempmisc=(String) jTable1.getValueAt(n,0);
                templocation=(String) jTable1.getValueAt(n,4);
                tempCd=(String) jTable1.getValueAt(n,5);
                tempPb=(String) jTable1.getValueAt(n,6);
                tempHg=(String) jTable1.getValueAt(n,7);
                tempCr=(String) jTable1.getValueAt(n,8);
                tempBr=(String) jTable1.getValueAt(n,9);
                tempResult=(String) jTable1.getValueAt(n,10);
                if(tempmisc==null){
                    break;
                }else if(tempmisc.trim().equals("")){
                    break;
                }else{
                    if(templocation.indexOf("PCI1 SLOT")!=-1){
                       addcell(ws,7,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PCI2 SLOT")!=-1){
                      addcell(ws,8,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PCI3 SLOT")!=-1){
                       addcell(ws,9,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PCIE16 SLOT")!=-1){
                       addcell(ws,10,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PCIE1 SLOT")!=-1){
                       addcell(ws,11,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                   }else if(templocation.indexOf("VGA")!=-1){
                       addcell(ws,12,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                   }else if(templocation.indexOf("COM")!=-1){
                       addcell(ws,13,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("LPT")!=-1){
                      addcell(ws,14,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                   }else if(templocation.indexOf("ATX1 SLOT")!=-1){
                       addcell(ws,15,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("IDE SLOT")!=-1){
                       addcell(ws,16,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("FDD SLOT")!=-1){
                       addcell(ws,17,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("DIMM SLOT")!=-1){
                       addcell(ws,18,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("USB LAN")!=-1){
                       addcell(ws,19,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("AUDIO")!=-1){
                       addcell(ws,20,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PSKBM")!=-1){
                       addcell(ws,21,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PCI1 底板")!=-1){
                       addcell(ws,22,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PCI2 底板")!=-1){
                       addcell(ws,23,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PCI3 底板")!=-1){
                       addcell(ws,24,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PCIE16底板")!=-1){
                       addcell(ws,25,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("PCIE1底板")!=-1){
                       addcell(ws,26,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("DIMM 底板")!=-1){
                       addcell(ws,27,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("IDE 底板")!=-1){
                      addcell(ws,28,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("FDD 底板")!=-1){
                      addcell(ws,29,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("序號 LABEL")!=-1){
                      addcell(ws,30,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("制程 LABEL")!=-1){
                       addcell(ws,31,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("卡號 LABEL")!=-1){
                      addcell(ws,32,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }else if(templocation.indexOf("機種 LABEL")!=-1){
                       addcell(ws,33,tempCd,tempPb,tempHg,tempCr,tempBr,tempResult);
                    }
                    
                }
                
            }
            
            
            wb.write();
            wb.close();
            rw.close();
            fos.close();
        }catch (WriteException ex) {
                ex.printStackTrace();
        }catch (BiffException ex) {
            ex.printStackTrace();
        } catch (IOException ex) {
            ex.printStackTrace();
        }
    
// TODO 將在此處加入您的處理代碼：
    }                                        

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                         
        if(jTextField2.getText().trim().equals("")){
            JOptionPane.showMessageDialog(this,"請先輸入MISC","提示",JOptionPane.INFORMATION_MESSAGE);
        }else{
             try {
                    Connection conn=con.getConnection();
                    Statement stmt=conn.createStatement();
                    String misc=jTextField2.getText().trim();
                    String sql="select MISC,LINE,SAMPLE,TIME_T,LOCATION_T,CD,PB,HG,CR,BR,RESULT,INSPECTOR FROM " +
                            "SFISUSER.ECSM_OQC_ROHS WHERE TRIM(MISC)='"+misc+"'";
//                    System.out.println(sql);
                    ResultSet rs=stmt.executeQuery(sql);
                    int i=0;
                    while(rs.next()){
                        if(i>=5){
                            break;
                        }
                        jTable1.setValueAt(rs.getString(1),i,0);
                        jTable1.setValueAt(rs.getString(2),i,1);
                        jTable1.setValueAt(rs.getString(3),i,2);
                        jTable1.setValueAt(rs.getString(4),i,3);
                        jTable1.setValueAt(rs.getString(5),i,4);
                        jTable1.setValueAt(rs.getString(6),i,5);
                        jTable1.setValueAt(rs.getString(7),i,6);
                        jTable1.setValueAt(rs.getString(8),i,7);
                        jTable1.setValueAt(rs.getString(9),i,8);
                        jTable1.setValueAt(rs.getString(10),i,9);
                        jTable1.setValueAt(rs.getString(11),i,10);
                        jTable1.setValueAt(rs.getString(12),i,11);
//                        System.out.println(rs.getString(1));
                        i++;
                    }
                    rs.close();
                    stmt.close();
                    conn.close();
                    
                }
                catch(Exception e) {
                    e.printStackTrace();
                }  
        }
        
        
// TODO 將在此處加入您的處理代碼：
    }                                        
    
    
    // 變數宣告 - 不進行修改                     
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable jTable1;
    private javax.swing.JTextField jTextField2;
    // 變數宣告結束                   
    
}
 
heyongbing02
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
JXL操作EXCEL的各个类的解析.doc
01-09
JXL操作EXCEL的各个类的解析.doc
JXL操作Excel
lao_wang_tou的博客
07-25 1468
 一、创建文件  拟生成一个名为“test.xls”的Excel文件，其中第一个工作表被命名为 “第一页”，大致效果如下： ? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 ...
jxl操作Excel
不会飞的菜鸟的博客
04-18 269
jxl操作Excel: package jrh.jxl.excel; import java.io.File; import java.io.IOException; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.Writabl
jxl操作excel
心如止水博客
11-20 232
添加公式代码 String formula = "SUM(H" + (i + 3) + "-I+" + (i + 3) + ")"; sheet.addCell(new Formula(9, i + 3, formula, contentWCF)); 注意:函数前面不需要= 例:"=SUM(H" + (i + 3) + "-I+" + (i + 3) + ")";
java 操作excel jxl_java 中JXL操作Excel实例详解
weixin_33805938的博客
03-05 643
java 中JXL操作Excel实例详解发布于 2021-1-2|复制链接摘记: JXL操作Excel前言：jxl是一个韩国人写的java操作excel的工具, 在开源世界中，有两套比较有影响的API可 供使用，一个是POI，一个是jExcelAPI。其中功能相对POI比较弱一点。但jExcelAPI对中文支持非常好，API是纯 ..JXL操作Excel前言：jxl是一个韩国人写的java操作ex...
java jxl使用_JAVA中使用JXL操作EXCEL
weixin_31446315的博客
02-16 84
Workbook rwb = null;WorkbookSettings workbookSettings = new WorkbookSettings();workbookSettings.setEncoding("GB2312");try {rwb = Workbook.getWorkbook(is, workbookSettings);} catch (IOException e) {e.p...
jxl操作excel表格
lingmao555的博客
04-21 592
基础内容来自http://blog.csdn.net/z562743237/article/details/8592012 项目中我们经常会遇到表格的操作，目前用的比较多的是jxl和poi两种方式操作表格。以下是用jxl读取表格和生成表格的方法。 package com.sunyard.iccs.report.util; import java.io.File; import java.i
JXL 操作Excel
zou493451860的专栏
05-03 374
JXL操作Excel的一些常用对象、方法，数据写入到Excel模版中 package com.zsd.tool; import java.io.File; import java.io.FileInputStream; import java.io.InputStream; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; impo
java 操作excel jxl,JAVA中使用JXL操作EXCEL
weixin_33958871的博客
03-20 218
Workbook rwb = null;WorkbookSettings workbookSettings = new WorkbookSettings();workbookSettings.setEncoding("GB2312");try {rwb = Workbook.getWorkbook(is, workbookSettings);} catch (IOException e) {e.p...
JXL操作excel
12-23 47
需要的JAR包：jxl-2.4.2.jar import java.io.File; import java.io.IOException; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; import jxl.write.Label; import jxl.wr...
java jxl_JXL操作Excel
weixin_28839629的博客
02-16 136
jxl是一个韩国人写的java操作excel的工具,在开源世界中，有两套比较有影响的API可供使用，一个是POI，一个是jExcelAPI。其中功能相对POI比较弱一点。但jExcelAPI对中文支持非常好，API是纯Java的，并不依赖Windows系统，即使运行在Linux下，它同样能够正确的处理Excel文件。另外需要说明的是，这套API对图形和图表的支持很有限，而且仅仅识别PNG格式...
利用jxl操作excel文件
12-04
利用jxl操作excel文件，提取exce文件数据生成txt文件。
jxl操作excel写入数据不覆盖原有数据示例
09-04
网上很多例子，都是用Jxl读或者写excel，本文实现的功能就是将数据源in.xls的第几行第几列数据写入到out.xls的第几行第几列，不覆盖out.xls其他原有的数据。
jxl操作excel.pdf
09-30
jxl操作excel.pdf
pytho爬取南京房源成交价信息并导入到excel
IT_Octopus的博客
04-29 652
python爬取南京房源成交信息
VBA提取Excel工作表名称
BeijixingVBA的博客
04-29 454
VBA提取Excel工作表名称。
json转excel
最新发布
dgiij的博客
05-03 415
前面有介绍过excel文件转换成json文件的方法，那json文件转excel文件呢？如果json文件里数据格式都是统一的话，那么也比较容易就转。在项目文件夹下有待转换json文件，转出的xlsx文件也存放在此，这样就可以执行以下命令转换json文件到excel文件了。
工具类，包含线程池，excel图片处理
xnian_的博客
04-30 543
【代码】工具类，包含线程池，excel图片处理。
jxl读写excel文件
05-13
jxl是一款Java操作Excel的开源库，可以方便地对Excel文件进行读写操作。以下是一个简单的示例： 首先需要导入jxl库的jar包，然后创建一个Workbook对象，用于打开Excel文件： ```java Workbook workbook = Workbook...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值