总结以前整理的知识点之Android读取Excel文件内容

废话不多说直接上代码： 需要导入jxl.jar
ReadExcelActivity.java 
package com.example.moreutils;

import java.io.File;

import com.example.numberproject.R; 
import com.example.numberproject.R.layout;

import android.app.Activity; 
import android.os.Bundle; 
import android.os.Environment; 
import android.text.method.ScrollingMovementMethod; 
import android.view.Menu; 
import android.view.MenuItem; 
import android.widget.TextView; 
import jxl.Sheet; 
import jxl.Workbook;

public class ReadExcelActivity extends Activity {

TextView text1 = null;
TextView text2 = null;
@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_read_excel);


    text1 = (TextView) findViewById(R.id.text1);
    text2 = (TextView) findViewById(R.id.text2);

    text2.setMovementMethod(ScrollingMovementMethod.getInstance());
    text2.setText("");

    readExcelFile();
}

public void readExcelFile() { 
    try {
        //jxl.jar能否正确使用和JDK版本有关，如果不成功，尝试调整编译的JDK版本看看
        File file = new File(Environment.getExternalStorageDirectory().getPath()+"/Download/2016.xls");
        if(!file.exists())
        {
            text1.setText("没有找到相应的EXCEL文件...");
        }
        else
        {
             Workbook book = Workbook.getWorkbook(file); 
             System.out.println(">>>>>>number of sheet "+book.getNumberOfSheets()); 
             // 获得第一个工作表对象            
             Sheet sheet = book.getSheet(0); 
             int Rows = sheet.getRows(); 
             int Cols = sheet.getColumns(); 
             text1.setText("当前工作表的名字:" + sheet.getName());
             text1.append("\n");
             text1.append("总行数:" + Rows+"\n");
             text1.append("总列数:" + Cols+"\n");
            // System.out.println("当前工作表的名字:" + sheet.getName()); 
             //System.out.println("总行数:" + Rows); 
            // System.out.println("总列数:" + Cols); 
             for (int i = 0; i < Rows; ++i)
             { 
                 for (int j = 0; j < Cols; ++j) 
                 { 
                     // getCell(Col,Row)获得单元格的值 
                    text2.append((sheet.getCell(j, i)).getContents() + "\t\t\t\t");
                    // System.out.print((sheet.getCell(j, i)).getContents() + "\t"); 
                 } 
                 text2.append("\n");
                 //System.out.print("\n"); 
             } 
             book.close();
        }


    } catch (Exception e) { 
        System.out.println(e); 
    }

}

}

jxl 下载地址：http://download.csdn.net/download/u012539700/10026857