Java读Excel使用POI--复制粘贴简单代码Excel中存在电话号或长数字_java excel文件导入手机号码数字长-CSDN博客

本文链接：https://blog.csdn.net/Wu_Application/article/details/89641411

本文介绍了如何使用Java的POI库处理Excel文件，特别是在处理包含电话号码或长数字的情况下，提供了复制粘贴操作的简单代码示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

        try {
            //String encoding = "GBK";
            File excel = new File(excelPath);
            if (excel.isFile() && excel.exists()) {   //判断文件是否存在
                String[] split = excel.getName().split("\\.");  //.是特殊字符，需要转义！！！！！
                Workbook wb;
                //根据文件后缀（xls/xlsx）进行判断
                if ( "xls".equals(split[1])){
                    FileInputStream fis = new FileInputStream(excel);   //文件流对象
                    wb = new HSSFWorkbook(fis);
                }else if ("xlsx".equals(split[1])){
                    wb = new XSSFWorkbook(excel);
                }else {
                    System.out.println("文件类型错误!");
                    return null;
                }

                //开始解析
                Sheet sheet = wb.getSheetAt(0);     //读取sheet 0

                int firstRowIndex = sheet.getFirstRowNum()+1;   //第一行是列名，所以不读
                int lastRowIndex = sheet.getLastRowNum();
                System.out.println("firstRowIndex: "+firstRowIndex);
                System.out.println("lastRowIndex: "+lastRowIndex);

                for(int rIndex = firstRowIndex; rIndex <= lastRowIndex; rIndex++) {   //遍历行
                    System.out.println("rIndex: " + rIndex);
                    Row row = sheet.getRow(rIndex);
                    if (row != null) {
                        int firstCellIndex = row.getFirstCellNum();
                        int lastCellIndex = row.getLastCellNum();
                        for (int cIndex = firstCellIndex; cIndex < lastCellIndex; cIndex++) {   //遍历列
                            Cell cell = row.getCell(cIndex);
                            String cellValue = "";
                            if (cell != null) {
                            	// 以下是判断数据的类型
            					switch (cell.getCellType()) {
            					case HSSFCell.CELL_TYPE_NUMERIC: // 数字
            						DecimalFormat df = new DecimalFormat("0");
            						cellValue = df.format(cell.getNumericCellValue());
            						break;
            					case HSSFCell.CELL_TYPE_STRING: // 字符串
            						cellValue = cell.getStringCellValue();
            						break;
            					case HSSFCell.CELL_TYPE_BOOLEAN: // Boolean
            						cellValue = cell.getBooleanCellValue() + "";
            						break;
            					case HSSFCell.CELL_TYPE_FORMULA: // 公式
            						cellValue = cell.getCellFormula() + "";
            						break;
            					case HSSFCell.CELL_TYPE_BLANK: // 空值
            						cellValue = "";
            						break;
            					case HSSFCell.CELL_TYPE_ERROR: // 故障
            						cellValue = "非法字符";
            						break;
            					default:
            						cellValue = "未知类型";
            						break;
            					}
            					System.out.println(cell.toString()+" ---> " + cellValue);
                            }
                        }
                    }
                    System.out.println("------------------");
                }
            } else {
                System.out.println("找不到指定的文件");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }

使用到的参数：

String excelPath = realPath + "\\" + nameFile;

导的包：

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;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;

即可使用