package com.lxw.test3d.Service;
|
|
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.xssf.usermodel.XSSFWorkbook;
|
|
import java.io.File;
|
import java.io.FileInputStream;
|
import java.io.FileNotFoundException;
|
import java.io.IOException;
|
|
public class Workexecise {
|
public static void main(String[] args) throws IOException {
|
|
FileInputStream in = null;
|
Workbook workBook=null;
|
try {
|
in = new FileInputStream(new File("E:\\ffmpeg\\2.xls"));
|
workBook= new XSSFWorkbook(in) ;
|
} catch (FileNotFoundException e) {
|
e.printStackTrace();
|
}
|
Sheet sheet0 = workBook.getSheetAt(0);// 获取Sheet工作簿
|
Row row = sheet0.getRow(0);// 获取行
|
Cell cell = row.getCell(0);
|
String str = cell.getStringCellValue();// 如果单元格中的数据时字符串
|
double num = cell.getNumericCellValue();// 如果单元格中的数据时数字
|
System.out.println(str);
|
|
}
|
}
|
