Android 中读写excel 中的类容

最新推荐文章于 2024-05-27 11:03:05 发布

CS_ZLF

最新推荐文章于 2024-05-27 11:03:05 发布

阅读量405

点赞数

分类专栏： Android

本文链接：https://blog.csdn.net/qq_33838022/article/details/52586961

版权

Android 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

import android.content.Context;
import android.os.Environment;
import android.os.StatFs;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.Menu;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableImage;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;

public class MainActivity extends AppCompatActivity {
    TextView txt = null;
    Button b = null;
    String result;
    String path = "mnt/sdcard/test.xls";//注意！文件路径 这句代码里 mnt和sdcard的使用，这就是系统的sd卡的路径，之后加上 自己的文件名，此例中为test.xls

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        b = (Button) findViewById(R.id.btn);
        txt = (TextView) findViewById(R.id.txt);
        writeExcel(path);<span style="white-space:pre">		</span>//将 文件路径代入 writeExcel写入函数
        result = readExcel(path,0,0);
        txt.setText(result);
    }

    public void writeExcel(String fileName) {
        WritableWorkbook wwb = null;
        try {
            // 创建一个可写入的工作薄(Workbook)对象
            wwb = Workbook.createWorkbook(new File(fileName));
        } catch (IOException e) {
            e.printStackTrace();
        }
        if (wwb != null) {
            // 第一个参数是工作表的名称，第二个是工作表在工作薄中的位置
            WritableSheet ws = wwb.createSheet("sheet1", 0);
            // 在指定单元格插入数据
            Label lbl1 = new Label(0, 0, "Excel");
            Label bll2 = new Label(1, 0, "的操作");
            try {
                ws.addCell(lbl1);
                ws.addCell(bll2);
            } catch (RowsExceededException e1) {
                e1.printStackTrace();
            } catch (WriteException e1) {
                e1.printStackTrace();
            }
            try {
                // 从内存中写入文件中
                wwb.write();
                wwb.close();
            } catch (IOException e) {
                e.printStackTrace();
            } catch (WriteException e) {
                e.printStackTrace();
            }
        }

    }
    public String readExcel(String path, int x, int y) {
        String content = "";
        try {
            Workbook book = Workbook.getWorkbook(new File(path));
            Sheet sheet = book.getSheet(0);
            // 得到x行y列所在单元格的内容
            String cellStr = sheet.getRow(x)[y].getContents();
            content = cellStr;

        } catch (BiffException e) {
            content = "";
            e.printStackTrace();
        } catch (IOException e) {
            content = "";
            e.printStackTrace();
        }
        return content;

    }
}