readexcel.java

Java源代码,使用JBulider开发的上传类,可以上传图片,铃声.

package com.owner.demo;

import java.io.FileInputStream;
import java.io.InputStream;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import java.util.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class ReadExcel {
  public ReadExcel() {
  }

  public static void ReadUA(String filename)throws Exception
  {
    try
    {
      String phonename = "";
      String useragent = "";
      String picwidth = "";
      String picheight = "";
      String pictype = "";
      String ringnum = "";
      String ringtype = "";
      String iSQL = "";

      //首先构造一个输入流
      InputStream is = new FileInputStream(filename);
      //jxl的Workbook得到这个输入流
      //jxl.Workbook rwb = Workbook.getWorkbook(is);
      Workbook rwb = Workbook.getWorkbook(is);
      //Workbook得到第一个sheet
      Sheet[] sheets = rwb.getSheets(); //获得当前Excel表共有几个sheet
      int p = sheets.length;
      //System.out.println("此表共有几个sheet--->" + p);
      System.out.println("此表共有" + p + "个sheet");
      for (int w = 0; w < p; w++) { //将每个sheet中的内容全部读取出来
        //在从Excel中读取数据的时候不需要知道每个sheet有几行，有那多少列
        Sheet rs = rwb.getSheet(w);
        int rows = rs.getRows();
        int cols = rs.getColumns();
        for (int d = 0; d < rows; d++) {
          //行循环,Excel的行列是从（0，0）开始的
          for (int t = 0; t < cols; t++) {
            //列循环
            Cell cell = rs.getCell(t, d);
            String strb = cell.getContents();
            //int a = cell.getColumn();
            if(d != 0){
              switch(t){
                case 0:
                  phonename = strb;
                case 1:
                  useragent = strb;
                case 2:
                  picwidth = strb;
                case 3:
                  picheight = strb;
                case 4:
                  pictype = strb;
                case 5:
                  ringnum = strb;
                case 6:
                  ringtype = strb;
                default:
                  break;
              }
            }
          }
          System.out.println(phonename + "^^^" + useragent + "^^^");
        }
       }
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public static void main(String[] args) throws Exception{
    //ReadExcel readExcel1 = new ReadExcel();
    ReadUA("C:/useragent.xls");
  }

}