Android创建与读取Excel

主流的操作Excel的有两种方法，一种是通过poi包，另一种是通过jxl包。这里我主要讲解通过jxl包来读写Excel。

首先需要导入一个jxl.jar包。

下载地址：http://www.andykhan.com/jexcelapi/download.html

下载后的文件会包含jxl相关的API。

下面直接上代码：

WriteExcel.java

import java.io.File;

import java.io.IOException;

import java.util.Locale;

 

import jxl.CellView;

import jxl.Workbook;

import jxl.WorkbookSettings;

import jxl.format.UnderlineStyle;

import jxl.write.Formula;

import jxl.write.Label;

import jxl.write.Number;

import jxl.write.WritableCellFormat;

import jxl.write.WritableFont;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

import jxl.write.biff.RowsExceededException;

 

public class WriteExcel {

 

    private WritableCellFormat timesBoldUnderline;

    private WritableCellFormat times;

    private String inputFile;

 

    public void setOutputFile(String inputFile) {

        this.inputFile = inputFile;

    }

 

    public void write() throws IOException, WriteException {

        File file = new File(inputFile);

        WorkbookSettings wbSettings = new WorkbookSettings();

 

        wbSettings.setLocale(new Locale("en", "EN"));

 

        WritableWorkbook workbook = Workbook.createWorkbook(file, wbSettings);

        workbook.createSheet("Report", 0);

        WritableSheet excelSheet = workbook.getSheet(0);

        createLabel(excelSheet);

        createContent(excelSheet);

 

        workbook.write();

        workbook.close();

    }

 

    private void createLabel(WritableSheet sheet)

            throws WriteException {

       

        WritableFont times10pt = new WritableFont(WritableFont.TIMES, 10);

       

        times = new WritableCellFormat(times10pt);

      

        times.setWrap(true);

 

        WritableFont times10ptBoldUnderline = new WritableFont(WritableFont.TIMES, 10, WritableFont.BOLD, false,

                UnderlineStyle.SINGLE);

        timesBoldUnderline = new WritableCellFormat(times10ptBoldUnderline);

       

        timesBoldUnderline.setWrap(true);

 

        CellView cv = new CellView();

        cv.setFormat(times);

        cv.setFormat(timesBoldUnderline);

        cv.setAutosize(true);

 

       

        addCaption(sheet, 0, 0, "Header 1");

        addCaption(sheet, 1, 0, "This is another header");

 

 

    }

 

    private void createContent(WritableSheet sheet) throws WriteException,

            RowsExceededException {

       

        for (int i = 1; i < 10; i++) {

           

            addNumber(sheet, 0, i, i + 10);

           

            addNumber(sheet, 1, i, i * i);

        }

 

        StringBuffer buf = new StringBuffer();

        buf.append("SUM(A2:A10)");

        Formula f = new Formula(0, 10, buf.toString());

        sheet.addCell(f);

        buf = new StringBuffer();

        buf.append("SUM(B2:B10)");

        f = new Formula(1, 10, buf.toString());

        sheet.addCell(f);

 

        for (int i = 12; i < 20; i++) {

            addLabel(sheet, 0, i, "Boring text " + i);

            addLabel(sheet, 1, i, "Another text");

        }

    }

 

    private void addCaption(WritableSheet sheet, int column, int row, String s)

            throws RowsExceededException, WriteException {

        Label label;

        label = new Label(column, row, s, timesBoldUnderline);

        sheet.addCell(label);

    }

 

    private void addNumber(WritableSheet sheet, int column, int row,

                           Integer integer) throws WriteException, RowsExceededException {

        Number number;

        number = new Number(column, row, integer, times);

        sheet.addCell(number);

    }

 

    private void addLabel(WritableSheet sheet, int column, int row, String s)

            throws WriteException, RowsExceededException {

        Label label;

        label = new Label(column, row, s, times);

        sheet.addCell(label);

    }

 

}

ReadExcel.java

import java.io.File;
import java.io.IOException;

import jxl.Cell;
import jxl.CellType;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

public class ReadExcel {
    private String inputFile;

    public void setInputFile(String inputFile) {
        this.inputFile = inputFile;
    }

    public void read() throws IOException  {
        File inputWorkbook = new File(inputFile);
        Workbook w;
        try {
            w = Workbook.getWorkbook(inputWorkbook);
          
            Sheet sheet = w.getSheet(0);

            for (int j = 0; j < sheet.getColumns(); j++) {
                for (int i = 0; i < sheet.getRows(); i++) {
                    Cell cell = sheet.getCell(j, i);
                    CellType type = cell.getType();
                    if (type == CellType.LABEL) {
                        System.out.println("I got a label "
                                + cell.getContents());
                    }

                    if (type == CellType.NUMBER) {
                        System.out.println("I got a number "
                                + cell.getContents());
                    }

                }
            }
        } catch (BiffException e) {
            e.printStackTrace();
        }
    }

}

调运WriteExcel的代码：

    WriteExcel writeExcel=new WriteExcel();

    writeExcel.setOutputFile("/sdcard/test.xls");

    try {

        writeExcel.write();

    } catch (IOException e) {

        e.printStackTrace();

    } catch (WriteException e) {

        e.printStackTrace();

    }

 

    

     执行完WriteExcel后便会在Android虚拟机中生成test.xls文件

 

调运ReadExcel的代码：

ReadExcel readExcel=new ReadExcel();

    readExcel.setInputFile("/sdcard/test.xls");

    try {

        readExcel.read();

    } catch (IOException e) {

        e.printStackTrace();

    }