Android下Excel的操作

在Android下操作Excel和在j2se下操作是一样的，下载一个jxl.jar包，导入到android工程的构建路径中。加入权限

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE"/>
<uses-permission android:name="android.permission.MOUNT_UNMOUNT_FILESYSTEMS"/>

以下是一个小例子。

//详细参考     http://www.ibm.com/developerworks/cn/java/l-javaExcel/public class OperateExcelActivity extends Activity{     /** Called when the activity is first created. */     @Override     public void onCreate(Bundle savedInstanceState)     {         super.onCreate(savedInstanceState);         setContentView(R.layout.main);         TextView textView = (TextView)findViewById(R.id.tv);         String path = "mnt/sdcard/test.xls";         writeExcel(path);         textView.setText(readExcel(path,5,5)+readExcel(path,10,10));     }      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(5, 5, "Excel");             Label bll2 = new Label(10, 10, "的操作");             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;               }  }

更多相关文章

随机推荐