java½âÎöexcelÎļþµÄ·½·¨。本站提示廣大學習愛好者：（java½âÎöexcelÎļþµÄ·½·¨）文章只能為提供參考，不一定能成為您想要的結果。以下是java½âÎöexcelÎļþµÄ·½·¨正文
½¨Á¢¹¤³ÌÇ°ÐèÒªµ¼ÈëPOI°ü¡£POIÏà¹Øjar°üÏÂÔصØÖ·£ºhttp://poi.apache.org/download.html
1.½âÎö.xlsxºó׺ÃûµÄµÄEXCELÎļþ£º
package com.shuai.hello;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ReadExcel {
public static void main(String[] args) throws IOException {
//File file = new File("C:/Users.xlsx");
InputStream stream = new FileInputStream("C:/Users.xlsx");
XSSFWorkbook xssfWorkbook = new XSSFWorkbook(stream);
XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(0);
int rowstart = xssfSheet.getFirstRowNum();
int rowEnd = xssfSheet.getLastRowNum();
for(int i=rowstart;i<=rowEnd;i++)
{
XSSFRow row = xssfSheet.getRow(i);
if(null == row) continue;
int cellStart = row.getFirstCellNum();
int cellEnd = row.getLastCellNum();
for(int k=cellStart;k<=cellEnd;k++)
{
XSSFCell cell = row.getCell(k);
if(null==cell) continue;
switch (cell.getCellType())
{
case HSSFCell.CELL_TYPE_NUMERIC: // Êý×Ö
System.out.print(cell.getNumericCellValue()
+ "\t");
break;
case HSSFCell.CELL_TYPE_STRING: // ×Ö·û´®
System.out.print(cell.getStringCellValue()
+ "\t");
break;
case HSSFCell.CELL_TYPE_BOOLEAN: // Boolean
System.out.println(cell.getBooleanCellValue()
+ "\t");
break;
case HSSFCell.CELL_TYPE_FORMULA: // ¹«Ê½
System.out.print(cell.getCellFormula() + "\t");
break;
case HSSFCell.CELL_TYPE_BLANK: // ¿ÕÖµ
System.out.println(" ");
break;
case HSSFCell.CELL_TYPE_ERROR: // ¹ÊÕÏ
System.out.println(" ");
break;
default:
System.out.print("δ֪ÀàÐÍ ");
break;
}
}
System.out.print("\n");
}
}
}
/*String fileType = filePath.substring(filePath.lastIndexOf(".") + 1, filePath.length());
InputStream stream = new FileInputStream(filePath);
Workbook wb = null;
if (fileType.equals("xls")) {
wb = new HSSFWorkbook(stream);
} else if (fileType.equals("xlsx")) {
wb = new XSSFWorkbook(stream);
} else {
System.out.println("ÄúÊäÈëµÄexcel¸ñʽ²»ÕýÈ·");
}*/
2.½âÎöºó׺Ϊ.xlsµÄEXCELÎļþ£º
package com.shuai.hello;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class ReadXls {
public static void main(String[] args) throws IOException, IOException {
File file = new File("C:/Users/dengta/Desktop/ok1.xls");
POIFSFileSystem poifsFileSystem = new POIFSFileSystem(new FileInputStream(file));
HSSFWorkbook hssfWorkbook = new HSSFWorkbook(poifsFileSystem);
HSSFSheet hssfSheet = hssfWorkbook.getSheetAt(0);
int rowstart = hssfSheet.getFirstRowNum();
int rowEnd = hssfSheet.getLastRowNum();
for(int i=rowstart;i<=rowEnd;i++)
{
HSSFRow row = hssfSheet.getRow(i);
if(null == row) continue;
int cellStart = row.getFirstCellNum();
int cellEnd = row.getLastCellNum();
for(int k=cellStart;k<=cellEnd;k++)
{
HSSFCell cell = row.getCell(k);
if(null==cell) continue;
//System.out.print("" + k + " ");
//System.out.print("type:"+cell.getCellType());
switch (cell.getCellType())
{
case HSSFCell.CELL_TYPE_NUMERIC: // Êý×Ö
System.out.print(cell.getNumericCellValue()
+ " ");
break;
case HSSFCell.CELL_TYPE_STRING: // ×Ö·û´®
System.out.print(cell.getStringCellValue()
+ " ");
break;
case HSSFCell.CELL_TYPE_BOOLEAN: // Boolean
System.out.println(cell.getBooleanCellValue()
+ " ");
break;
case HSSFCell.CELL_TYPE_FORMULA: // ¹«Ê½
System.out.print(cell.getCellFormula() + " ");
break;
case HSSFCell.CELL_TYPE_BLANK: // ¿ÕÖµ
System.out.println(" ");
break;
case HSSFCell.CELL_TYPE_ERROR: // ¹ÊÕÏ
System.out.println(" ");
break;
default:
System.out.print("δ֪ÀàÐÍ ");
break;
}
}
System.out.print("\n");
}
}
}
ÒÔÉϾÍÊDZ¾ÎĵÄÈ«²¿ÄÚÈÝ£¬Ï£Íû¶Ô´ó¼ÒµÄѧϰÓÐËù°ïÖú£¬Ò²Ï£Íû´ó¼Ò¶à¶àÖ§³Ö½Å±¾Ö®¼Ò¡£
