借助于apathe的poi.jar，由于上傳文件不支持.jar所以請下載后將文件改為.jar，在應用程序中添加poi.jar包，并將需要讀取的excel文件放入根目錄即可

本例使用java來讀取excel的內容并展出出結果，代碼如下：

importjava.io.BufferedInputStream;

importjava.io.File;

importjava.io.FileInputStream;

importjava.io.FileNotFoundException;

importjava.io.IOException;

importjava.text.DecimalFormat;

importjava.text.SimpleDateFormat;

importjava.util.ArrayList;

importjava.util.Arrays;

importjava.util.Date;

importjava.util.List;

importorg.apache.poi.hssf.usermodel.HSSFCell;

importorg.apache.poi.hssf.usermodel.HSSFDateUtil;

importorg.apache.poi.hssf.usermodel.HSSFRow;

importorg.apache.poi.hssf.usermodel.HSSFSheet;

importorg.apache.poi.hssf.usermodel.HSSFWorkbook;

importorg.apache.poi.poifs.filesystem.POIFSFileSystem;

publicclassExcelOperate {

publicstaticvoidmain(String[] args)throwsException {

File file =newFile("ExcelDemo.xls");

String[][] result =getData(file, 1);

introwLength = result.length;

for(inti=0;i<rowLength;i++) {

for(intj=0;j<result[i].length;j++) {

System.out.

}

System.out.println();

}

}

/**

*讀取Excel的內容，第一維數組存儲的是一行中格列的值，二維數組存儲的是多少個行

*@paramfile讀取數據的源Excel

*@paramignoreRows讀取數據忽略的行數，比喻行頭不需要讀入忽略的行數為1

*@return讀出的Excel中數據的內容

*@throwsFileNotFoundException

*@throwsIOException

*/

publicstaticString[][] getData(File file,intignoreRows)

throwsFileNotFoundException, IOException {

List<String[]> result =newArrayList<String[]>();

introwSize = 0;

BufferedInputStream in =newBufferedInputStream(newFileInputStream(

file));

//打開HSSFWorkbook

POIFSFileSystem fs =newPOIFSFileSystem(in);

HSSFWorkbook wb =newHSSFWorkbook(fs);

HSSFCell cell =null;

for(intsheetIndex = 0; sheetIndex < wb.getNumberOfSheets(); sheetIndex++) {

HSSFSheet st = wb.getSheetAt(sheetIndex);

//第一行為標題，不取

for(introwIndex = ignoreRows; rowIndex <= st.getLastRowNum(); rowIndex++) {

HSSFRow row = st.getRow(rowIndex);

if(row ==null) {

continue;

}

inttempRowSize = row.getLastCellNum() + 1;

if(tempRowSize > rowSize) {

rowSize = tempRowSize;

}

String[] values =newString[rowSize];

Arrays.fill(values,"");

booleanhasValue =false;

for(shortcolumnIndex = 0; columnIndex <= row.getLastCellNum(); columnIndex++) {

String value ="";

cell = row.getCell(columnIndex);

if(cell !=null) {

//注意：一定要設成這個，否則可能會出現亂碼

cell.setEncoding(HSSFCell.ENCODING_UTF_16);

switch(cell.getCellType()) {

caseHSSFCell.CELL_TYPE_STRING:

value = cell.getStringCellValue();

break;

caseHSSFCell.CELL_TYPE_NUMERIC:

if(HSSFDateUtil.isCellDateFormatted(cell)) {

Date date = cell.getDateCellValue();

if(date !=null) {

value =newSimpleDateFormat("yyyy-MM-dd")

.format(date);

}else{

value ="";

}

}else{

value =newDecimalFormat("0").format(cell

.getNumericCellValue());

}

break;

caseHSSFCell.CELL_TYPE_FORMULA:

//導入時如果為公式生成的數據則無值

if(!cell.getStringCellValue().equals("")) {

value = cell.getStringCellValue();

}else{

value = cell.getNumericCellValue() +"";

}

break;

caseHSSFCell.CELL_TYPE_BLANK:

break;

caseHSSFCell.CELL_TYPE_ERROR:

value ="";

break;

caseHSSFCell.CELL_TYPE_BOOLEAN:

value = (cell.getBooleanCellValue() ==true?"Y"

:"N");

break;

default:

value ="";

}

}

if(columnIndex == 0 && value.trim().equals("")) {

break;

}

values[columnIndex] =rightTrim(value);

hasValue =true;

}

if(hasValue) {

result.add(values);

}

}

}

in.close();

String[][] returnArray =newString[result.size()][rowSize];

for(inti = 0; i < returnArray.length; i++) {

returnArray[i] = (String[]) result.get(i);

}

returnreturnArray;

}

/**

*去掉字符串右邊的空格

*@paramstr要處理的字符串

*@return處理后的字符串

*/

publicstaticString rightTrim(String str) {

if(str ==null) {

return"";

}

intlength = str.length();

for(inti = length - 1; i >= 0; i--) {

if(str.charAt(i) != 0x20) {

break;

}

length--;

}

returnstr.substring(0, length);

}

}