frame1.java~56~

excel格式文件读入读出问题（在jbuilder环境下）

package zhcxapplication;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
import  java.io.FileInputStream;
import  java.io.FileOutputStream;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.*;
import  java.io.IOException;
import  java.io.*;
import javax.swing.event.*;
    /**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class Frame1 extends JFrame {

  JPanel contentPane;
  JPanel jPanel1 = new JPanel();
  JPanel jPanel2 = new JPanel();
  JPanel jPanel3 = new JPanel();
  TitledBorder titledBorder1;
  TitledBorder titledBorder2;
  CardLayout cardLayout2 = new CardLayout();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JFileChooser jFileChooser1 = new JFileChooser();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  JPanel jPanel4 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JButton jButton1 = new JButton();
  JOptionPane jOptionPane1 = new JOptionPane();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JButton jButton6 = new JButton();
  BorderLayout borderLayout1 = new BorderLayout();
  JLabel jLabel7 = new JLabel();
  JTextField jTextField2 = new JTextField("请输入保存路径：");
  String[][][] name = new String[5][5100][100];
  int  x,y,t;
  //Construct the frame

  public Frame1() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  //Component initialization
  private void jbInit() throws Exception  {
    contentPane = (JPanel) this.getContentPane();
    jButton1.setBounds(new Rectangle(133, 193, 116, 49));
    jButton1.setFont(new java.awt.Font("Dialog", 1, 20));
    jButton1.setText("下一步");
    jButton1.addActionListener(new Frame1_jButton1_actionAdapter(this));
    jButton1.addMouseListener(new Frame1_jButton1_mouseAdapter(this));
    jPanel4.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", 3, 34));
    jLabel1.setForeground(Color.magenta);
    jLabel1.setText("欢迎使用加序程序");
    jLabel1.setBounds(new Rectangle(47, 66, 289, 90));
    jButton5.setBounds(new Rectangle(63, 210, 77, 31));
    jButton5.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton5.setText("继续");
    jButton5.addActionListener(new Frame1_jButton5_actionAdapter(this));
    jButton5.addMouseListener(new Frame1_jButton5_mouseAdapter(this));
    jButton4.setBounds(new Rectangle(238, 212, 95, 30));
    jButton4.setFont(new java.awt.Font("Dialog", 0, 15));
    jButton4.setText("退出");
    jButton4.addMouseListener(new Frame1_jButton4_mouseAdapter(this));
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 30));
    jLabel4.setForeground(Color.red);
    jLabel4.setText("谢谢使用！！");
    jLabel4.setBounds(new Rectangle(176, 161, 211, 45));
    jLabel3.setFont(new java.awt.Font("Serif", 3, 25));
    jLabel3.setText("您转换后的文件将被保存");
    jLabel3.setBounds(new Rectangle(35, 8, 295, 108));
    jPanel3.setLayout(null);
    jFileChooser1.setBackground(Color.lightGray);
    jFileChooser1.setForeground(Color.black);
    jFileChooser1.setFileSelectionMode(0);
    jFileChooser1.addContainerListener(new Frame1_jFileChooser1_containerAdapter(this));
    jFileChooser1.addMouseListener(new Frame1_jFileChooser1_mouseAdapter(this));
    jButton3.setBounds(new Rectangle(270, 198, 83, 33));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 19));
    jButton3.setText("确定");
    jButton3.addMouseListener(new Frame1_jButton3_mouseAdapter(this));
    jButton2.setBounds(new Rectangle(269, 145, 85, 33));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 19));
    jButton2.setText("浏览");
    jButton2.addMouseListener(new Frame1_jButton2_mouseAdapter(this));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(52, 168, 177, 47));
    jLabel2.setBackground(Color.gray);
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 25));
    jLabel2.setForeground(Color.blue);
    jLabel2.setText("请输入所要加序的文档");
    jLabel2.setBounds(new Rectangle(45, 44, 295, 78));
    jPanel2.setFont(new java.awt.Font("Dialog", 3, 25));
    titledBorder1 = new TitledBorder("");
    titledBorder2 = new TitledBorder("");
    contentPane.setLayout(borderLayout1);
    this.setSize(new Dimension(400, 300));
    this.setTitle("加序窗口");
    jPanel1.setBackground(Color.cyan);
    jPanel1.setEnabled(true);
    jPanel1.setFont(new java.awt.Font("Dialog", 0, 12));
    jPanel1.setForeground(Color.black);
    jPanel1.setBorder(titledBorder2);
    jPanel1.setLayout(cardLayout2);
    jPanel2.setLayout(null);
    jOptionPane1.setLayout(null);
    jOptionPane1.setFont(new java.awt.Font("Dialog", 0, 30));
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 26));
    jLabel5.setText("您输入的文件不正确！");
    jLabel5.setBounds(new Rectangle(55, 26, 271, 98));
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 28));
    jLabel6.setForeground(Color.red);
    jLabel6.setText("请 重 新 输 入 ！");
    jLabel6.setBounds(new Rectangle(87, 126, 237, 53));
    jButton6.setBounds(new Rectangle(127, 216, 95, 37));
    jButton6.setFont(new java.awt.Font("Dialog", 0, 20));
    jButton6.setText("确定");
    jButton6.addActionListener(new Frame1_jButton6_actionAdapter(this));
    jLabel7.setToolTipText("");
    jLabel7.setText("");
    jLabel7.setBounds(new Rectangle(90, 39, 200, 36));
    jTextField2.setToolTipText("");
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(101, 116, 144, 34));
    jPanel3.add(jLabel3, null);
    jPanel3.add(jButton5, null);
    jPanel3.add(jButton4, null);
    jPanel3.add(jLabel4, null);
    jPanel3.add(jTextField2, null);
    jPanel1.add(jPanel2, "jPanel2");
    jPanel1.add(jPanel3, "jPanel3");
    jPanel2.add(jLabel2, null);
    jPanel2.add(jTextField1, null);
    jPanel2.add(jButton2, null);
    jPanel2.add(jButton3, null);
    jPanel1.add(jFileChooser1,  "jFileChooser1");
    jPanel1.add(jPanel4,  "jPanel4");
    jPanel4.add(jLabel1, null);
    jPanel4.add(jButton1, null);
    jPanel4.add(jLabel7, null);
    contentPane.add(jPanel1, BorderLayout.CENTER);
    jPanel1.add(jOptionPane1, "jOptionPane1");
    jOptionPane1.add(jLabel6, null);
    jOptionPane1.add(jButton6, null);
    jOptionPane1.add(jLabel5, null);
  }
  //Overridden so we can exit when window is closed
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      System.exit(0);
    }
  }

  void jButton1_mouseClicked(MouseEvent e) {
cardLayout2.show(jPanel1,"jPanel2");

  }

  void jButton1_actionPerformed(ActionEvent e) {

  }

  void jButton2_mouseClicked(MouseEvent e) {
  jFileChooser1.show()  ;
    int  rel=jFileChooser1.showOpenDialog(jPanel1);

    if(rel==JFileChooser.APPROVE_OPTION);
    {
      jFileChooser1.setDialogTitle("open file");
      jFileChooser1.setApproveButtonText("open");
      String f1=jFileChooser1.getSelectedFile() .getName() ;
      String f2=jFileChooser1.getCurrentDirectory().getPath();
      jTextField1.setText(f2+f1);
      String myfile1;
      myfile1=f2+f1;

       //  String myfile1=jTextField1.getText() ;
              openFile(myfile1);

   }
  }

  void jFileChooser1_mouseClicked(MouseEvent e) {

 }


  void jFileChooser1_componentAdded(ContainerEvent e) {

  }

  void jButton3_mouseClicked(MouseEvent e)
  {
   cardLayout2.show(jPanel1,"jPanel3");
  }

  void jButton5_mouseClicked(MouseEvent e) {
cardLayout2.show(jPanel1,"jPanel4");
  }

  void jButton4_mouseClicked(MouseEvent e) {
System.exit(0);
  }
public  void   openFile(String f7)
  {
  try{
    String value = null;
    HSSFWorkbook workbook1 = new HSSFWorkbook(new FileInputStream(f7));
    int m = workbook1.getNumberOfSheets();
         x=m;
      for(int k=0;k<m;k++)
      {
        HSSFSheet sheet1 = workbook1.getSheetAt(0);
        int n = sheet1.getPhysicalNumberOfRows();
           y=n;
        for (int i = 0; i < n; i++) {
          HSSFRow row1 = sheet1.getRow(i);
          int z = row1.getPhysicalNumberOfCells();
            t=z;
          for (int j = 0; j < z; j++) {
            HSSFCell cell1 = row1.getCell( (short) j);


           if (cell1.getCellType() == HSSFCell.CELL_TYPE_NUMERIC ) {
              value = (int)cell1.getNumericCellValue() +"";
            }
         if (cell1.getCellType() == HSSFCell.CELL_TYPE_STRING) {
              value =  cell1.getStringCellValue();
             }
        /* if (cell1.getCellType() == HSSFCell.ENCODING_COMPRESSED_UNICODE) {
              value = "" + cell1.getEncoding();
            }*/
         /*  if (cell1.getCellType() == HSSFCell.ENCODING_UTF_16) {
              value = "" + cell1.getEncoding();

            }*/
    /*    if (cell1.getCellType() == HSSFCell.CELL_TYPE_BLANK) {
              value = null;
            }
         if (cell1.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN) {
              value = "" + cell1.getBooleanCellValue();
            }
         if (cell1.getCellType() == HSSFCell.CELL_TYPE_ERROR) {
              value = "" + cell1.getErrorCellValue();

            }*/

           if (cell1.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
              value =""+"1010";
            }

            jLabel7.setText("");
            name[k][i][j] =value;
          }
        }
      }
  }catch (IOException e){}
  }


public void  outfile(String f8)
  {
    try{
         FileOutputStream fo=new FileOutputStream(f8);
         HSSFWorkbook workbook2 = new HSSFWorkbook();
        for(int k=0;k<1;k++)
        {
            HSSFSheet sheet2 = workbook2.createSheet();

            workbook2.setSheetName(k,"h"+k);
          for(short i=0;i<y;i++)
           {
           HSSFRow row2 = sheet2.createRow(i);

             for(short j=0;j<t;j++)
              {
              HSSFCell cell2 = row2.createCell(j);

             if(i==0||j==0)
              {
              cell2.setCellValue(""+name[k][i][j]);
              }
             else
              {
              cell2.setCellValue(""+j+":"+name[k][i][j]);
              }
             }

          }
       }
   workbook2.write(fo);
    fo.close() ;
}catch (IOException e){}


  }


  void jButton5_actionPerformed(ActionEvent e)
  {
        String s1;
        s1=jTextField2.getText() ;
         outfile(s1);
  }

  void jButton6_actionPerformed(ActionEvent e) {

  }


}

class Frame1_jButton1_mouseAdapter extends java.awt.event.MouseAdapter {
  Frame1 adaptee;

  Frame1_jButton1_mouseAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButton1_mouseClicked(e);
  }
}

class Frame1_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton1_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Frame1_jButton2_mouseAdapter extends java.awt.event.MouseAdapter {
  Frame1 adaptee;

  Frame1_jButton2_mouseAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButton2_mouseClicked(e);
  }
}

class Frame1_jFileChooser1_mouseAdapter extends java.awt.event.MouseAdapter {
  Frame1 adaptee;

  Frame1_jFileChooser1_mouseAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jFileChooser1_mouseClicked(e);
  }
}

class Frame1_jButton3_mouseAdapter extends java.awt.event.MouseAdapter {
  Frame1 adaptee;

  Frame1_jButton3_mouseAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButton3_mouseClicked(e);
  }
}

class Frame1_jFileChooser1_containerAdapter extends java.awt.event.ContainerAdapter {
  Frame1 adaptee;

  Frame1_jFileChooser1_containerAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void componentAdded(ContainerEvent e) {
    adaptee.jFileChooser1_componentAdded(e);
  }
}

class Frame1_jButton5_mouseAdapter extends java.awt.event.MouseAdapter {
  Frame1 adaptee;

  Frame1_jButton5_mouseAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButton5_mouseClicked(e);
  }
}

class Frame1_jButton4_mouseAdapter extends java.awt.event.MouseAdapter {
  Frame1 adaptee;

  Frame1_jButton4_mouseAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButton4_mouseClicked(e);
  }
}

class Frame1_jButton5_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton5_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class Frame1_jButton6_actionAdapter implements java.awt.event.ActionListener {
  Frame1 adaptee;

  Frame1_jButton6_actionAdapter(Frame1 adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}