package poiexample; import java.io.FileInputStream; import java.io.InputStream; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; public class GettingCellContentExample { public static void main(String[] args) { try (InputStream inp = new FileInputStream("Learnfk.xls")) { Workbook wb = WorkbookFactory.create(inp); Sheet sheet = wb.getSheetAt(0); Row row = sheet.getRow(2); Cell cell = row.getCell(3); if (cell != null) System.out.println("Data: "+cell); else System.out.println("Cell is empty"); }catch(Exception e) { System.out.println(e); } } }
这是无涯教程要读取的电子表格文件。
执行完上面的示例后,它将从指定的单元格中读取值,并将以下输出生成到控制台。
输出:
Data: 200.0
祝学习愉快!(内容编辑有误?请选中要编辑内容 -> 右键 -> 修改 -> 提交!)