在Android下操作Excel和在j2se下操作是一样的,下载一个jxl.jar包,导入到android工程的构建路径中。加入权限
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>
<uses-permission android:name="android.permission.MOUNT_UNMOUNT_FILESYSTEMS"/>
以下是一个小例子。
1 //详细参考 http://www.ibm.com/developerworks/cn/java/l-javaExcel/
2 public class OperateExcelActivity extends Activity
3 {
4
5 @Override
6 public void onCreate(Bundle savedInstanceState)
7 {
8 super.onCreate(savedInstanceState);
9 setContentView(R.layout.main);
10 TextView textView = (TextView)findViewById(R.id.tv);
11 String path = "mnt/sdcard/test.xls";
12 writeExcel(path);
13 textView.setText(readExcel(path,5,5)+readExcel(path,10,10));
14 }
15
16 public void writeExcel(String fileName)
17 {
18 WritableWorkbook wwb = null;
19 try
20 {
21 //创建一个可写入的工作薄(Workbook)对象
22 wwb = Workbook.createWorkbook(new File(fileName));
23 } catch (IOException e)
24 {
25 e.printStackTrace();
26 }
27 if (wwb != null)
28 {
29 // 第一个参数是工作表的名称,第二个是工作表在工作薄中的位置
30 WritableSheet ws = wwb.createSheet("sheet1", 0);
31 // 在指定单元格插入数据
32 Label lbl1 = new Label(5, 5, "Excel");
33 Label bll2 = new Label(10, 10, "的操作");
34 try
35 {
36 ws.addCell(lbl1);
37 ws.addCell(bll2);
38 } catch (RowsExceededException e1)
39 {
40 e1.printStackTrace();
41 } catch (WriteException e1)
42 {
43 e1.printStackTrace();
44 }
45 try
46 {
47 // 从内存中写入文件中
48 wwb.write();
49 wwb.close();
50 } catch (IOException e)
51 {
52 e.printStackTrace();
53 } catch (WriteException e)
54 {
55 e.printStackTrace();
56 }
57 }
58 }
59
60 public String readExcel(String path, int x, int y)
61 {
62 String content = "";
63 try
64 {
65 Workbook book = Workbook.getWorkbook(new File(path));
66 Sheet sheet = book.getSheet(0);
67 //得到x行y列所在单元格的内容
68 String cellStr = sheet.getRow(x)[y].getContents();
69 content = cellStr;
70
71 } catch (BiffException e)
72 {
73 content = "";
74 e.printStackTrace();
75 } catch (IOException e)
76 {
77 content = "";
78 e.printStackTrace();
79 }
80 return content;
81
82
83 }
84
85 }
标签:String,Excel,content,printStackTrace,wwb,catch,操作,Android,path
From: https://blog.51cto.com/u_548275/6237992