java读取excel文件,用jxl包,列的名称不固定怎么办?

excelJava

1个回答

写回答

浮游

2026-01-30 05:28

+ 关注

etc
etc

处理列名不固定的情况可以通过使用workbook对象的列标签来实现。首先,我们需要获取到workbook对象,并创建一个worksheet对象。然后,使用worksheet对象的getcolumn标签来获取到列标签,最后将列标签赋值给变量即可。以下是一个示例代码片段:Javaimport org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataFormat;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataFormat;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;//读取excel文件import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;//读取excel文件import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;//读取excel文件import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;//读取excel文件import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;//读取excel文件import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;//读取excel文件import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;//读取excel文件import org.apache.poi.xssf.usermodel.XSSFCellStyle;import org.apache.poi.xssf.usermodel.XSSFDataValidationSequence;import org.apache.poi.xssf.usermodel.XSSFDataValidationRule;import org.apache.poi.xssf.usermodel.XSSFFont;import org.apache.poi.xssf.usermodel.XSSFRange;import org.apache.poi.xssf.usermodel.XSSFRow;//读取excel文件import org.apache.poi.xssf.usermodel.XSSFCellStyle;...

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号