android的poi读写数据代码
时间: 2023-06-03 16:02:06 浏览: 65
我可以回答这个问题。Android中使用POI库可以读写Microsoft Office格式的文件,包括Excel文件。以下是一个简单的示例代码:
// 导入POI库
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Cell;
// 读取Excel文件
public void readExcelFile(File file) {
try {
FileInputStream inputStream = new FileInputStream(file);
HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
HSSFSheet sheet = workbook.getSheetAt(0);
Iterator<Row> rowIterator = sheet.iterator();
while (rowIterator.hasNext()) {
Row row = rowIterator.next();
Iterator<Cell> cellIterator = row.cellIterator();
while (cellIterator.hasNext()) {
Cell cell = cellIterator.next();
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
System.out.print(cell.getStringCellValue() + "\t");
break;
case Cell.CELL_TYPE_NUMERIC:
System.out.print(cell.getNumericCellValue() + "\t");
break;
}
}
System.out.println();
}
workbook.close();
inputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}
// 写入Excel文件
public void writeExcelFile(File file) {
try {
FileOutputStream outputStream = new FileOutputStream(file);
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("Sheet1");
Row row = sheet.createRow((short)0);
Cell cell = row.createCell(0);
cell.setCellValue("Hello World");
workbook.write(outputStream);
workbook.close();
outputStream.close();
} catch (Exception e) {
e.printStackTrace();
}
}