我想用Java从excel中导入一列数据分别赋值给一个一维数组。

excelJava

1个回答

写回答

补过课

2026-01-30 05:33

+ 关注

Java
Java

您可以使用Java中的JexcelAPI库来从excel文件中读取数据。首先,您需要导入JexcelAPI库并创建一个工作簿对象。然后,使用工作簿对象的getcolumnCount()方法获取列数,并使用getRowCount()方法获取行数。接下来,您可以使用columnName和rowIndex参数从工作簿对象的getcell()方法中获取单元格的内容,并将其赋值给相应的数组元素。以下是一个示例代码片段:Javaimport org.jbundle.lib.jxtflite;import org.jbundle.lib.jxtflite.worksheet.Worksheet;import org.jbundle.lib.jxtflite.worksheet.WorksheetFormat;import org.jbundle.lib.jxtflite.worksheet.cell.Cell;import org.jbundle.lib.jxtflite.worksheet.cell.CellType;import org.jbundle.lib.jxtflite.worksheet.pane.Pane;import org.jbundle.lib.jxtflite.worksheet.pane.PaneBuilder;import org.jbundle.lib.jxtflite.worksheet.pane.PaneArrangement;import org.jbundle.lib.jxtflite.worksheet.pane.PaneArrangementBuilder;import org.jbundle.lib.jxtflite.worksheet.pane.Range;import org.jbundle.lib.jxtflite.worksheet.pane.RangeBuilder;import org.jbundle.lib.jxtflite.worksheet.sheet.Sheet;import org.jbundle.lib.jxtflite.worksheet.sheet.SheetBuilder;import org.jbundle.lib.jxtflite.worksheet.sheet.SheetType;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetType;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypeBuilder;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypeList;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypes;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypesBuilder;import org.jbundle.lib.jxtflite.utils.DateUtils;import org.jbundle.lib.jxtflite.utils.DateUtils.DateUtilsBuilder;import org.jbundle.lib.jxtflite.utils.excelUtils;import org.jbundle.lib.jxtflite.utils.excelUtils.excelUtilsBuilder;import org.jbundle.lib.jxtflite.utils.IntUtils;import org.jbundle.lib.jxtflite.utils.IntUtils.IntUtilsBuilder;import org.jbundle.lib.jxtflite.utils.SortedSetUtils;import org.jbundle.lib.jxtflite.utils.SortedSetUtils.SortedSetUtilsBuilder;import org.jbundle.lib.jxtflite.utils.URLUtils;import org.jbundle.lib.jxtflite.utils.URLUtils.URLUtilsBuilder;import org.jbundle.lib.jxtflite.worksheet.pane.PaneArrangementBuilder;import org.jbundle.lib.jxtflite.worksheet.sheet.SheetBuilder;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypeBuilder;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypeList;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypesBuilder;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypesList;import org.jbundle.lib.jxtflite.worksheet.sheet.Worksheet;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetBuilder;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetType;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypeBuilder;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypeList;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypes;import org.jbundle.lib.jxtflite.worksheet.sheet.WorksheetTypesBuilder;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetBuilder;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypeBuilder;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypeList;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesBuilder;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList.WorksheetType;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList.WorksheetType.SheetType;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList.WorksheetType.SheetType.Sheet;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList.WorksheetType.Sheet.Sheet;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList.WorksheetType.Sheet.Sheet;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList.WorksheetType.Sheet.Sheet.Sheet;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList.WorksheetType.Sheet.Sheet.Sheet.Sheet;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList.WorksheetType.Sheet.Sheet.Sheet.Sheet.Sheet;import org.jbundle.lib.jxtflite.worksheet.worksheet.WorksheetTypesList.WorksheetType.Sheet.Sheet.Sheet....

举报有用(0分享收藏

Copyright © 2025 IZhiDa.com All Rights Reserved.

知答 版权所有 粤ICP备2023042255号