importjava.io.FileInputStream;importjava.io.FileOutputStream;importjava.io.IOException;importjava.io.InputStream;importjava.io.OutputStream;importorg.apache.poi.hssf.user...
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
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;
public class pair {
public static void main(String[] args) throws IOException {
String path = "y:/";
String fileName = "abc";
String fileType = "xlsx";
// writer(path, fileName, fileType);
read(path, fileName, fileType);
}
public static void read(String path,String fileName,String fileType) throws IOException
{
InputStream stream = new FileInputStream(path+fileName+"."+fileType);
Workbook wb = null;
if (fileType.equals("xls")) {
wb = new HSSFWorkbook(stream);
}
else if (fileType.equals("xlsx")) {
wb = new XSSFWorkbook(stream);
}
else {
System.out.println("Wrong excel format");
}
Sheet sheet1 = wb.getSheetAt(0);
for (Row row : sheet1) {
for (Cell cell : row) {
System.out.print(cell.getNumericCellValue()+" ");
}
System.out.println();
}
}
}
这其中的
for (Row row : sheet1) {
for (Cell cell : row)
是什么意思,用比较笨的传统的for循环应该怎么写?求高手指导!急求!谢谢
展开