本文介绍了如何在 JavaFX 应用程序中从 Excel 读取数据?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我正在创建一个 JavaFX FXMl 应用程序，将休眠作为 Java 中的 ORM.我想使用休眠从 Excel 读取数据并将其存储到 MySQL，但无法创建工作簿.
我花了几个小时阅读教程和其他帖子，无论是在 SO 还是其他网站上，都没有接受的答案或评论对我有帮助.
在我的 Form_Main.fxml 文件中，我有一个按钮调用相关方法从 Excel 读取数据.我添加了以下 JAR 文件:
* poi-4.1.0
* poi-ooxml-4.1.0
* poi-ooxml-schemas-4.1.0
* xmlbeans-3.0.1
* commons-collections4-4.2
到项目.我读取数据的导入如下:
import org.apache.poi.xssf.usermodel.XSSFWorkbook;导入 org.apache.poi.xssf.usermodel.XSSFSheet;导入 org.apache.poi.xssf.usermodel.XSSFRow;我定义的方法是:
FileInputStream _File = new FileInputStream(new File("D:\\Students_Info.xlsx"));XSSFWorkbook _Workbook = new XSSFWorkbook(_File);XSSFSheet _Sheet = _Workbook.getSheetAt(0);XSSFRow _Row;剩下的代码即将使用hibernate将数据写入MySQL.但它不起作用.
当我调试我的程序时，在一行:
XSSFWorkbook _Workbook = new XSSFWorkbook(_File);它跳转到文件 FXMLLoader.java 行:
catch (InvocationTargetException 异常) {抛出新的运行时异常(异常)；}我的堆栈跟踪(如果我是对的)是:
[java] 线程JavaFX 应用程序线程"中的异常 java.lang.RuntimeException: java.lang.reflect.InvocationTargetException[java] 在 javafx.fxml.FXMLLoader$MethodHandler.invoke(FXMLLoader.java:1774)[java] 在 javafx.fxml.FXMLLoader$ControllerMethodEventHandler.handle(FXMLLoader.java:1657)[java] 在 com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)[java] 在 com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)[java] 在 com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)[java] 在 com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)[java] 在 com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)[java] 在 com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)[java] 在 com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)[java] 在 com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)[java] 在 com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)[java] 在 com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)[java] 在 com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)[java] 在 com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)[java] 在 javafx.event.Event.fireEvent(Event.java:198)[java] 在 javafx.scene.Node.fireEvent(Node.java:8411)[java] 在 javafx.scene.control.Button.fire(Button.java:185)[java] 在 com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)[java] 在 com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)[java] 在 com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)[java] 在 com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)[java] 在 com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)[java] 在 com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)[java] 在 com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)[java] 在 com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)[java] 在 com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)[java] 在 com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)[java] 在 com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)[java] 在 com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)[java] 在 com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)[java] 在 com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)[java] 在 com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)[java] 在 com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)[java] 在 javafx.event.Event.fireEvent(Event.java:198)[java] 在 javafx.scene.Scene$MouseHandler.process(Scene.java:3757)[java] 在 javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)[java] 在 javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)[java] 在 javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)[java] 在 com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:394)[java] 在 com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:295)[java] 在 java.security.AccessController.doPrivileged(Native Method)[java] 在 com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$358(GlassViewEventHandler.java:432)[java] 在 com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:410)[java] 在 com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:431)[java] 在 com.sun.glass.ui.View.handleMouseEvent(View.java:555)[java] 在 com.sun.glass.ui.View.notifyMouse(View.java:937)[java] 在 com.sun.glass.ui.win.WinApplication._runLoop(Native Method)[java] 在 com.sun.glass.ui.win.WinApplication.lambda$null$152(WinApplication.java:177)[java] 在 java.lang.Thread.run(Thread.java:748)[java] 引起:java.lang.reflect.InvocationTargetException[java] 在 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[java] 在 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[java] 在 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[java] 在 java.lang.reflect.Method.invoke(Method.java:498)[java] 在 sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)[java] 在 sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)[java] 在 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[java] 在 java.lang.reflect.Method.invoke(Method.java:498)[java] 在 sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)[java] 在 javafx.fxml.FXMLLoader$MethodHandler.invoke(FXMLLoader.java:1771)[java] ... 48 更多[java] 引起:java.lang.NoClassDefFoundError: org/apache/commons/collections4/ListValuedMap[java] at school_system.Model.TblStudent.importDataFromFile(TblStudent.java:107)[java] at school_system.Controllers.Controller_Main.handleImportDataButtonAction(Controller_Main.java:34)[java] ... 58 更多[java] 引起:java.lang.ClassNotFoundException:org.apache.commons.collections4.ListValuedMap[java] 在 java.net.URLClassLoader.findClass(URLClassLoader.java:382)[java] 在 java.lang.ClassLoader.loadClass(ClassLoader.java:424)[java] 在 sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)[java] 在 java.lang.ClassLoader.loadClass(ClassLoader.java:357)[java] ... 60多 解决方案
这是我创建的用于读取 EXCEL 文件的实用程序.希望它可以帮助你.Main 方法仅用于测试目的，可以删除.
代码使用
List>excelData = ExcelFileUtility.readExcelFile("fileName.xlsx");完整代码:
import java.io.FileInputStream;导入 java.io.FileNotFoundException;导入 java.io.IOException;导入 java.io.InputStream;导入 java.util.ArrayList;导入 java.util.List;导入 org.apache.poi.EncryptedDocumentException;导入 org.apache.poi.ss.usermodel.Cell;导入静态 org.apache.poi.ss.usermodel.CellType.BLANK；导入静态 org.apache.poi.ss.usermodel.CellType.BOOLEAN;导入静态 org.apache.poi.ss.usermodel.CellType.FORMULA;导入静态 org.apache.poi.ss.usermodel.CellType.NUMERIC;导入静态 org.apache.poi.ss.usermodel.CellType.STRING;导入 org.apache.poi.ss.usermodel.DataFormatter;导入 org.apache.poi.ss.usermodel.Row;导入 org.apache.poi.ss.usermodel.Sheet;导入 org.apache.poi.ss.usermodel.Workbook;导入 org.apache.poi.ss.usermodel.WorkbookFactory;/**** @作者 blj0011*/公共类 ExcelFileUtility{/*** @param args 命令行参数*/public static void main(String[] args){readExcelFileWithHeaderFirstRow("Database_Details_Report_AAA.xlsx 的副本", false).forEach((t) -> {t.forEach((z) -> {System.out.print(z + " - ");});System.out.println();});}公共静态列表>readExcelFile(字符串文件名){列表>excelContent = new ArrayList();int columnCounter = 0;int rowCounter = 0;试试 (InputStream inputStream = new FileInputStream(fileName)) {DataFormatter formatter = new DataFormatter();工作簿工作簿 = WorkbookFactory.create(inputStream);Sheet sheet = workbook.getSheetAt(0);for(行行:工作表){列表tempList = new ArrayList();对于(单元格单元格:行){String text = formatter.formatCellValue(cell);System.out.print(++columnCounter + ":" + text);System.out.println(text.length());tempList.add(text);}列计数器 = 0;excelContent.add(tempList);++行计数器；//用于测试//如果(行计数器 == 5){// 休息;//}//System.out.println(String.join(" - ", tempList));//System.out.println(tempList.size());}}捕获(IOException | EncryptedDocumentException ex){System.out.println(ex.toString());}返回excel内容；}公共静态列表>readExcelFileWithHeaderFirstRow(String fileName, boolean allCellHaveData){列表>sheetData = new ArrayList();int headerCount = 0;试试 (FileInputStream fis = new FileInputStream(fileName);工作簿 wb = WorkbookFactory.create(fis)) {Sheet sheet = wb.getSheetAt(0);for (int i = 0; i < sheet.getPhysicalNumberOfRows(); i++) {行行 = sheet.getRow(i);字符串值;列表rowData = new ArrayList();//System.out.println("\nROW " + row.getRowNum() + " has " + row.getPhysicalNumberOfCells() + " cell(s).");//System.out.println("最后一个单元格编号:" + row.getLastCellNum());如果(我== 0){headerCount = row.getLastCellNum();}for (int c = 0; c ";rowData.add("");休息;案例布尔:value = "布尔值-" + cell.getBooleanCellValue();rowData.add(cell.getBooleanCellValue() ? "true" : "false");休息;案例错误:value = "错误值=" + cell.getErrorCellValue();rowData.add(Byte.toString(cell.getErrorCellValue()));休息;默认:value = "UNKNOWN value of type " + cell.getCellType();rowData.add(cell.getCellType().toString());}//System.out.println("CELL col=" + cell.getColumnIndex() + " VALUE=" + value);}别的 {//System.out.println("CELL col=" + " VALUE=" + "");rowData.add("");}}如果(！allCellHaveData){int currentRowCount = row.getLastCellNum();while (currentRowCount < headerCount) {rowData.add("");currentRowCount++;}}sheetData.add(rowData);}}抓住(FileNotFoundException前){System.out.println(ex);}捕获(IOException ex){System.out.println(ex);}返回表单数据；}}I am creating a JavaFX FXMl application with hibernate as ORM in Java. I want to read data from Excel and store it to MySQL using hibernate, but it fails to create Workbook.
I have spend hours to read tutorials and other posts whether in SO or other sites, neither accepted answers nor comments helped me.
In my Form_Main.fxml file I have a button that calls related method to read data from Excel. I have added following JAR files:
* poi-4.1.0
* poi-ooxml-4.1.0
* poi-ooxml-schemas-4.1.0
* xmlbeans-3.0.1
* commons-collections4-4.2
to the project. My imports to read data are as follows:
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFRow;
the method I have defined is:
FileInputStream _File = new FileInputStream(new File("D:\\Students_Info.xlsx"));
XSSFWorkbook _Workbook = new XSSFWorkbook(_File);
XSSFSheet _Sheet = _Workbook.getSheetAt(0);
XSSFRow _Row;
The rest of code is about to writing data to MySQL using hibernate. But it doesn't work.
When I debug my program, at line:
XSSFWorkbook _Workbook = new XSSFWorkbook(_File);
It jumps to file FXMLLoader.java at line:
catch (InvocationTargetException exception) {
throw new RuntimeException(exception);
}
My Stack Trace (if I am correct) is:
[java] Exception in thread "JavaFX Application Thread" java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
[java] at javafx.fxml.FXMLLoader$MethodHandler.invoke(FXMLLoader.java:1774)
[java] at javafx.fxml.FXMLLoader$ControllerMethodEventHandler.handle(FXMLLoader.java:1657)
[java] at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
[java] at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
[java] at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
[java] at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
[java] at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
[java] at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
[java] at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
[java] at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
[java] at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
[java] at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
[java] at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
[java] at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
[java] at javafx.event.Event.fireEvent(Event.java:198)
[java] at javafx.scene.Node.fireEvent(Node.java:8411)
[java] at javafx.scene.control.Button.fire(Button.java:185)
[java] at com.sun.javafx.scene.control.behavior.ButtonBehavior.mouseReleased(ButtonBehavior.java:182)
[java] at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:96)
[java] at com.sun.javafx.scene.control.skin.BehaviorSkinBase$1.handle(BehaviorSkinBase.java:89)
[java] at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
[java] at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
[java] at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
[java] at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
[java] at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
[java] at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
[java] at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
[java] at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
[java] at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
[java] at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
[java] at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
[java] at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
[java] at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
[java] at javafx.event.Event.fireEvent(Event.java:198)
[java] at javafx.scene.Scene$MouseHandler.process(Scene.java:3757)
[java] at javafx.scene.Scene$MouseHandler.access$1500(Scene.java:3485)
[java] at javafx.scene.Scene.impl_processMouseEvent(Scene.java:1762)
[java] at javafx.scene.Scene$ScenePeerListener.mouseEvent(Scene.java:2494)
[java] at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:394)
[java] at com.sun.javafx.tk.quantum.GlassViewEventHandler$MouseEventNotification.run(GlassViewEventHandler.java:295)
[java] at java.security.AccessController.doPrivileged(Native Method)
[java] at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleMouseEvent$358(GlassViewEventHandler.java:432)
[java] at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:410)
[java] at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleMouseEvent(GlassViewEventHandler.java:431)
[java] at com.sun.glass.ui.View.handleMouseEvent(View.java:555)
[java] at com.sun.glass.ui.View.notifyMouse(View.java:937)
[java] at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
[java] at com.sun.glass.ui.win.WinApplication.lambda$null$152(WinApplication.java:177)
[java] at java.lang.Thread.run(Thread.java:748)
[java] Caused by: java.lang.reflect.InvocationTargetException
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:498)
[java] at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:71)
[java] at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:498)
[java] at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:275)
[java] at javafx.fxml.FXMLLoader$MethodHandler.invoke(FXMLLoader.java:1771)
[java] ... 48 more
[java] Caused by: java.lang.NoClassDefFoundError: org/apache/commons/collections4/ListValuedMap
[java] at school_system.Model.TblStudent.importDataFromFile(TblStudent.java:107)
[java] at school_system.Controllers.Controller_Main.handleImportDataButtonAction(Controller_Main.java:34)
[java] ... 58 more
[java] Caused by: java.lang.ClassNotFoundException: org.apache.commons.collections4.ListValuedMap
[java] at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
[java] at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
[java] at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
[java] ... 60 more
解决方案
Here is a utility I created to read EXCEL files. Hopefully, it can help you. The Main method is just for testing purposes and can be removed.
List<List<String>> excelData = ExcelFileUtility.readExcelFile("fileName.xlsx");
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import org.apache.poi.EncryptedDocumentException;
import org.apache.poi.ss.usermodel.Cell;
import static org.apache.poi.ss.usermodel.CellType.BLANK;
import static org.apache.poi.ss.usermodel.CellType.BOOLEAN;
import static org.apache.poi.ss.usermodel.CellType.FORMULA;
import static org.apache.poi.ss.usermodel.CellType.NUMERIC;
import static org.apache.poi.ss.usermodel.CellType.STRING;
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.ss.usermodel.WorkbookFactory;
/**
*
* @author blj0011
*/
public class ExcelFileUtility
{
/**
* @param args the command line arguments
*/
public static void main(String[] args)
{
readExcelFileWithHeaderFirstRow("Copy of Database_Details_Report_AAA.xlsx", false).forEach((t) -> {
t.forEach((z) -> {
System.out.print(z + " - ");
});
System.out.println();
});
}
public static List<List<String>> readExcelFile(String fileName)
{
List<List<String>> excelContent = new ArrayList();
int columnCounter = 0;
int rowCounter = 0;
try (InputStream inputStream = new FileInputStream(fileName)) {
DataFormatter formatter = new DataFormatter();
Workbook workbook = WorkbookFactory.create(inputStream);
Sheet sheet = workbook.getSheetAt(0);
for (Row row : sheet) {
List<String> tempList = new ArrayList();
for (Cell cell : row) {
String text = formatter.formatCellValue(cell);
System.out.print(++columnCounter + ": " + text);
System.out.println(text.length());
tempList.add(text);
}
columnCounter = 0;
excelContent.add(tempList);
++rowCounter;
//Used for testing
//if (rowCounter == 5) {
// break;
//}
//System.out.println(String.join(" - ", tempList));
//System.out.println(tempList.size());
}
}
catch (IOException | EncryptedDocumentException ex) {
System.out.println(ex.toString());
}
return excelContent;
}
public static List<List<String>> readExcelFileWithHeaderFirstRow(String fileName, boolean allCellHaveData)
{
List<List<String>> sheetData = new ArrayList();
int headerCount = 0;
try (FileInputStream fis = new FileInputStream(fileName);
Workbook wb = WorkbookFactory.create(fis)) {
Sheet sheet = wb.getSheetAt(0);
for (int i = 0; i < sheet.getPhysicalNumberOfRows(); i++) {
Row row = sheet.getRow(i);
String value;
List<String> rowData = new ArrayList();
//System.out.println("\nROW " + row.getRowNum() + " has " + row.getPhysicalNumberOfCells() + " cell(s).");
//System.out.println("last cell number: " + row.getLastCellNum());
if (i == 0) {
headerCount = row.getLastCellNum();
}
for (int c = 0; c < row.getLastCellNum(); c++) {
Cell cell = row.getCell(c);
if (cell != null) {
switch (cell.getCellType()) {
case FORMULA:
value = "FORMULA value=" + cell.getCellFormula();
rowData.add(cell.getCellFormula());
break;
case NUMERIC:
value = "NUMERIC value=" + cell.getNumericCellValue();
rowData.add(Double.toString(cell.getNumericCellValue()));
break;
case STRING:
value = "STRING value=" + cell.getStringCellValue();
rowData.add(cell.getStringCellValue());
break;
case BLANK:
value = "<BLANK>";
rowData.add("");
break;
case BOOLEAN:
value = "BOOLEAN value-" + cell.getBooleanCellValue();
rowData.add(cell.getBooleanCellValue() ? "true" : "false");
break;
case ERROR:
value = "ERROR value=" + cell.getErrorCellValue();
rowData.add(Byte.toString(cell.getErrorCellValue()));
break;
default:
value = "UNKNOWN value of type " + cell.getCellType();
rowData.add(cell.getCellType().toString());
}
//System.out.println("CELL col=" + cell.getColumnIndex() + " VALUE=" + value);
}
else {
//System.out.println("CELL col=" + " VALUE=" + "<My Blank>");
rowData.add("<My Blank>");
}
}
if (!allCellHaveData) {
int currentRowCount = row.getLastCellNum();
while (currentRowCount < headerCount) {
rowData.add("<Blank end column>");
currentRowCount++;
}
}
sheetData.add(rowData);
}
}
catch (FileNotFoundException ex) {
System.out.println(ex);
}
catch (IOException ex) {
System.out.println(ex);
}
return sheetData;
}
}
这篇关于如何在 JavaFX 应用程序中从 Excel 读取数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！