Android下Excel的操作

最新推荐文章于 2023-06-30 20:09:45 发布

bensantan

最新推荐文章于 2023-06-30 20:09:45 发布

阅读量350

点赞数

本文链接：https://blog.csdn.net/bensantan/article/details/40352947

版权

在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 }