A bit stuck here. I am trying to write a method: public void addAssignment(Strin

Question

A bit stuck here. I am trying to write a method:

public void addAssignment(String string) {
       try {
       //FileInputStream fsIP= new FileInputStream(new File("\DB\GradesDatabase.xlsx"));
       Sheet sheet = workbook.getSheet("IndividualContribs");
       int num = sheet.getRow(0).getPhysicalNumberOfCells();
       //Go to first empty slot on top row
       int firstEmpty = num+1;
       Row row = sheet.getRow(1);
       Cell column = row.getCell(firstEmpty);
       column.setCellValue(string);
       workbook.write(null);
       workbook.close();
       } catch (FileNotFoundException e) {
           e.printStackTrace();
       } catch (IOException e) {
           e.printStackTrace();
       }
   }

that passes the following junit test:

@Test
public void testAddAssignment() {
db.addAssignment("ASSIGNMENT: black-box testing");
db = new GradesDB(GRADES_DB);
assertEquals(4, db.getNumAssignments());
db.addAssignment("ASSIGNMENT: white-box testing");
db = new GradesDB(GRADES_DB);
assertEquals(5, db.getNumAssignments());
}

but it's not working...I think because I'm trying to call the file in my .java file, while the test file has it's own means of getting to the excel sheet:

GradesDB db = null;
static final String GRADES_DB_GOLDEN = "DB" + File.separator
+ "GradesDatabase-goldenversion.xlsx";
static final String GRADES_DB = "DB" + File.separator
+ "GradesDatabase.xlsx";

@Before
public void setUp() throws Exception {
FileSystem fs = FileSystems.getDefault();
Path dbfilegolden = fs.getPath(GRADES_DB_GOLDEN);
Path dbfile = fs.getPath(GRADES_DB);
Files.copy(dbfilegolden, dbfile, REPLACE_EXISTING);
db = new GradesDB(GRADES_DB);
}

@After
public void tearDown() throws Exception {
db = null;
}

Please help me write  public void addAssignment(String string) { correctly so that it does as this test is trying for (to insert something(s) in the first open space(s) in the next few rows in my excel DB:

Explanation / Answer

public void addAssignment(String string)

{

XSSFWorkbook db1 = new XSSFWorkbook(new FileInputStream(new File("\DB\GradesDatabase.xlsx")));

// import the file

XSSFSheet sheet = db1.getSheetAt(0);
       int num = sheet.getRow(0).getPhysicalNumberOfCells();
       //Go to first empty slot on top row
       int firstEmpty = num+1;
       Row row = sheet.getRow(1);
       Cell column = row.getCell(firstEmpty);
       column.setCellValue(string);
        db1.write(null);
        db1.close();
       } catch (FileNotFoundException e) {
           e.printStackTrace();
       } catch (IOException e) {
           e.printStackTrace();

}

Here, Apache POI is being used.

Add "import org.apache.poi.xssf.usermodel.XSSFSheet;" in the beginning.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.