java如何从excel中读取、写入信息（POI）

注意事项：

从excel中读取文件的内容应该没一行一列都有对应元素素，如下图所示：

---

POI读取excel代码：

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.LinkedList;
import java.util.List;


import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
import org.apache.poi.hssf.usermodel.HSSFDateUtil;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;
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.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.common.*;;


public class CreatAndReadExcel {
   
//测试主函数
//    private static String excel2003Path = "C:\\Users\\lenovo\\Desktop\\项目\\cdw.xls";
//    public static void main(String[] args) throws Exception {
   
//
//
        List<List<Object>> excel2007List = readExcel(excel2007Path);// 读取2007版Excel文件
//        List<List<Object>> excel2003List = readExcel(excel2003Path);// 读取2003版Excel文件
//        System.out.println(excel2003List.toString());
//        System.out.println(excel2003List.get(1).get(0));
//        
//        String str = "手打手打";
//        if (str.equals(excel2003List.get(1).get(0).toString()) ) {
   
//        	System.out.println("true");
//        }else {