if(31 == cell.getCellStyle().getFillForegroundColor()) //判断单元格前景色为淡蓝色

if(10 == book.getFontAt(cell.getCellStyle().getFontIndex()).getColor()) //判断单元格字体颜色为红色

if(0 == cell.getCellStyle().getFillForegroundColor()) //判断单元格前景色为淡蓝色

if(0 == book.getFontAt(cell.getCellStyle().getFontIndex()).getColor()) //判断单元格字体颜色为红色

 import java.io.FileInputStream;

 import java.io.FileNotFoundException;

 import java.io.IOException;

 import org.apache.poi.hssf.usermodel.HSSFWorkbook;

 import org.apache.poi.ss.usermodel.Cell;

 import org.apache.poi.ss.usermodel.DataFormatter;

 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 TestExcel {

     private static final DataFormatter FORMATTER = new DataFormatter();

     /**

      * 获取单元格内容

      *

      * @param cell

      *            单元格对象

      * @return 转化为字符串的单元格内容

      */

     private static String getCellContent(Cell cell) {

         return FORMATTER.formatCellValue(cell);

     }

     private static String getExcelValue(String filePath, int sheetIndex) {

         String value = "";

         try {

             // 创建对Excel工作簿文件

             Workbook book = null;

             try {

                 book = new XSSFWorkbook(new FileInputStream(filePath));

             } catch (Exception ex) {

                 book = new HSSFWorkbook(new FileInputStream(filePath));

             }

             Sheet sheet = book.getSheetAt(sheetIndex);

             // 获取到Excel文件中的所有行数

             int rows = sheet.getPhysicalNumberOfRows();

             // System.out.println("rows:" + rows);

             // 遍历行

             for (int i = 0; i < rows; i++) {

                 // 读取左上端单元格

                 Row row = sheet.getRow(i);

                 // 行不为空

                 if (row != null) {

                     // 获取到Excel文件中的所有的列

                     int cells = row.getPhysicalNumberOfCells();

                     // System.out.println("cells:" + cells);

                     // 遍历列

                     for (int j = 0; j < cells; j++) {

                         // 获取到列的值

                         Cell cell = row.getCell(j);

                         if (cell != null) {

                             // if (31 ==

                             // cell.getCellStyle().getFillForegroundColor() &&

                             // 10 ==

                             // book.getFontAt(cell.getCellStyle().getFontIndex()).getColor())

                             if (0 == cell.getCellStyle().getFillForegroundColor()

                                && 0 == book.getFontAt(cell.getCellStyle().getFontIndex()).getColor())

                                 value += "第" + (i + 1) + "行 第" + (j + 1) + "列 的内容是： " + getCellContent(cell) + ",";

                         }

                     }

                 }

             }

         } catch (FileNotFoundException e) {

             e.printStackTrace();

         } catch (IOException e) {

             e.printStackTrace();

         }

         return value;

     }

     public static void main(String[] args) {

         String filePath = "F://example.xls";

         int sheetIndex = 0;

         String[] val = getExcelValue(filePath, sheetIndex).split(",");

         for (int i = 0; i < val.length; i++) {

             System.out.println(val[i]);

         }

     }

 }