我是二年级学生。我必须完成我的java项目,但如果你们中的任何人都可以帮忙,我会面临一些问题。我的项目是使用java在excel工作表中输入学生的标记并计算标记的平均值。我写了下面的代码,但它无法正常工作......在java中使用excel表格
这里是我的代码...
import java.util.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.*;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.ss.util.*;
import java.io.*;
public class exceluser {
public static void main(String[] args){
String St_Id = "";
String Name = "";
int Marks = 0;
boolean keepRunning = true;
//Blank workbook
HSSFWorkbook workbook = new HSSFWorkbook();
//Blank sheet
HSSFSheet sheet = workbook.createSheet("Seating Details");
//create heading
Row rowHeading = sheet.createRow(0);
rowHeading.createCell(0).setCellValue("Student ID");
rowHeading.createCell(1).setCellValue("Student(s) Name");
rowHeading.createCell(2).setCellValue("Marks");
//Font size and style loop for my headers
for(int i = 0; i < 3; i++)
{
CellStyle stylerowHeading = workbook.createCellStyle();
Font font = workbook.createFont();
font.setBold(true);
font.setFontName(HSSFFont.FONT_ARIAL);
font.setFontHeightInPoints((short) 11);
stylerowHeading.setFont(font);
rowHeading.getCell(i).setCellStyle(stylerowHeading);
}
int rownum=1;
while(keepRunning){
Scanner scnr = new Scanner(System.in);
System.out.print("Enter student ID : ");
St_Id = scnr.nextLine();
if(St_Id.equals("EXIT"))
{
System.out.print("You have ended the program");
System.exit(0);
}
else
{
System.out.print("Enter the student name : ");
Name = scnr.nextLine();
System.out.print("Enter the marks of the student : ");
Marks = scnr.nextInt();
//This data needs to be written (Object[])
Map data = new TreeMap();
data.put("2", new Object[] {St_Id, Name, Marks});
//Iterate over data and write to sheet
Set keyset = data.keySet();
for(String Key : keyset)
{
Row row = sheet.createRow(rownum++);
Object [] objArr = data.get(Key);
int cellnum = 0;
for(Object obj : objArr)
{
Cell cell = row.createCell(cellnum++);
if(obj instanceof String)
{
cell.setCellValue((String)obj);
}
else if(obj instanceof Integer)
cell.setCellValue((Integer)obj);
}
}
if(!(St_Id.equals("EXIT")))
{
rownum++;
}
//Auto size my columns that will be filled out with user input info.
for (int i = 0; i < 3; i++)
{
sheet.autoSizeColumn(i);
}
}
try{
//save to excel file
FileOutputStream out = new FileOutputStream(new File("Student Grading Report.xls"));
workbook.write(out);
out.flush();
out.close();
System.out.println("Record added Succesfully...");
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e){
e.printStackTrace();
} catch (Exception e) {
System.out.println(e.getMessage());
}
}
}//pub static void end brace
}//pub class end brace
帮我在此代码,如果任何人都可以..这段代码执行时,它离开输入一个学生数据后,excel中的一行,以及找到学生平均分数的问题。
+0
正确缩进代码将帮助您查看代码中每个点发生了什么 –