我现在面临的问题是我要导入一个Excel文件并将其传递给其他类:
package cal;
import java.util.Scanner;
public class CalendarMain {
public static void main(String[] args) {
Scanner link = new Scanner(System.in);
System.out.println("Please insert the raw file link: ");
String excellink = link.nextLine();
link.close();
String[] excelLink = new String[] { excellink };
ShiftSetting.main(excelLink);
}
}
编译没有问题并通过命令提示进行运行,但是当将RAW文件链接粘贴到命令提示符中并单击Enter时,它给我这个错误:
C:UsersUsereclipse-workspaceCalendar_v1src>java cal.CalendarMain cal.ShiftSetting cal.PHNames
Please insert the raw file link:
C:UsersUserDesktopWORK2019raw.xlsx
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/poi/ss/usermodel/Row
at cal.CalendarMain.main(CalendarMain.java:16)
Caused by: java.lang.ClassNotFoundException: org.apache.poi.ss.usermodel.Row
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 1 more
fyi,当我在日食上运行它时,这个问题永远不会出现。但是,当我尝试在命令提示符下运行时,它会给我这个错误。第16行实际上是这样的行:ShiftSetting.main(excelLink);
我还提供shiftSetting.java文件
package cal;
import java.io.File;
import java.io.FileInputStream;
import java.util.ArrayList;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.DataFormatter;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ShiftSetting {
public static void main(String[] excelLink) {
ArrayList<String> shiftname = new ArrayList<String>();
ArrayList<String> shiftcode = new ArrayList<String>();
try {
FileInputStream file = new FileInputStream(new File("C:\Users\User\Desktop\WORK\shiftnameall.xlsx"));
XSSFWorkbook wb = new XSSFWorkbook(file);
XSSFSheet sheet = wb.getSheetAt(0);
DataFormatter formatter = new DataFormatter();
String cellValue = null;
for (int rowNum = 0; rowNum < sheet.getLastRowNum() + 1; rowNum++) {
Row r = sheet.getRow(rowNum);
String val = null;
for (int m = 0; m < r.getLastCellNum(); m = m + 2) {
Cell cell = r.getCell(m);
val = formatter.formatCellValue(cell);
shiftname.add(val);
}
}
for (int rowNum = 0; rowNum < sheet.getLastRowNum() + 1; rowNum++) {
Row r = sheet.getRow(rowNum);
String val = null;
for (int m = 1; m < r.getLastCellNum(); m++) {
Cell cell = r.getCell(m);
val = formatter.formatCellValue(cell);
shiftcode.add(val);
}
}
} catch (Exception e) {
e.printStackTrace();
}
/* PHDatesArray.main(excelLink, shiftname, shiftcode); */
}
}
有人知道如何解决这个问题?
我解决了这个问题。实际上,这与Apache POI的版本或系统变量中的路径无关。这只是我在命令提示符上的路径,我错误地写了它。
我已经将所有.jar文件都放在一个文件夹中的文件夹中。
因此,我运行命令以这样的编译:
javac -cp jars/*;. *.java
然后运行它,我像这样写了
java -cp calendar/jars/*; calendar.nameofclass1, calendar.nameofclass2