excel在android读取,写入,更新数据
2013年10月07日
⁄ 综合
⁄ 共 4350字 ⁄ 字号
小 中 大
-
public class ReadExcel extends Activity {
-
-
@Override
-
public void onCreate(Bundle savedInstanceState) {
-
super.onCreate(savedInstanceState);
-
setContentView(R.layout.main);
-
-
-
writeExcel("mnt/sdcard/test.xls");
-
}
-
-
public void readExcel() {
-
try {
-
-
-
-
-
InputStream is = new FileInputStream("mnt/sdcard/test.xls");
-
-
Workbook book = Workbook
-
.getWorkbook(new File("mnt/sdcard/test.xls"));
-
book.getNumberOfSheets();
-
-
Sheet sheet = book.getSheet(0);
-
int Rows = sheet.getRows();
-
int Cols = sheet.getColumns();
-
System.out.println("当前工作表的名字:" + sheet.getName());
-
System.out.println("总行数:" + Rows);
-
System.out.println("总列数:" + Cols);
-
for (int i = 0; i < Cols; ++i) {
-
for (int j = 0; j < Rows; ++j) {
-
-
System.out
-
.print((sheet.getCell(i, j)).getContents() + "\t");
-
}
-
System.out.print("\n");
-
}
-
-
Cell cell1 = sheet.getCell(0, 0);
-
String result = cell1.getContents();
-
System.out.println(result);
-
book.close();
-
} catch (Exception e) {
-
System.out.println(e);
-
}
-
}
-
-
public void createExcel() {
-
try {
-
-
WritableWorkbook book = Workbook.createWorkbook(new File(
-
"mnt/sdcard/test.xls"));
-
-
-
WritableSheet sheet1 = book.createSheet("第一页", 0);
-
WritableSheet sheet2 = book.createSheet("第三页", 2);
-
-
-
Label label = new Label(0, 0, "test");
-
-
-
sheet1.addCell(label);
-
-
-
-
-
jxl.write.Number number = new jxl.write.Number(1, 0, 555.12541);
-
sheet2.addCell(number);
-
-
-
book.write();
-
book.close();
-
} catch (Exception e) {
-
System.out.println(e);
-
}
-
}
-
-
-
-
-
-
-
public void updateExcel(String filePath) {
-
try {
-
Workbook rwb = Workbook.getWorkbook(new File(filePath));
-
WritableWorkbook wwb = Workbook.createWorkbook(new File(
-
"d:/new.xls"), rwb);
-
WritableSheet ws = wwb.getSheet(0);
-
WritableCell wc = ws.getWritableCell(0, 0);
-
-
Label label = (Label) wc;
-
label.setString("The value has been modified");
-
wwb.write();
-
wwb.close();
-
rwb.close();
-
} catch (Exception e) {
-
e.printStackTrace();
-
}
-
}
-
-
public static void writeExcel(String filePath) {
-
try {
-
-
WritableWorkbook wwb = Workbook.createWorkbook(new File(filePath));
-
-
WritableSheet ws = wwb.createSheet("Sheet1", 0);
-
-
-
-
-
-
-
-
-
-
-
-
ws.addImage(new WritableImage(5, 5, 2, 5, new File(
-
"mnt/sdcard/nb.png")));
-
wwb.write();
-
wwb.close();
-
} catch (Exception e) {
-
System.out.println(e.toString());
-
}
-
}
-
}