assertThat(modified.workbook(), sameWorkbook(getWorkbook("shouldReplaceCellsInComplicatedExampleTemplateExpected.xls")));
}
@Test
public void shouldAppendRow() throws IOException, ParseException {
RowBuilder row = aRow()
.withString(column(A), "This")
.withString(column(C), "Row")
.withString(column(D), "was")
.withString(column(E), "inserted")
.withString(column(H), "here")
.withString(column(I), "by")
.withString(column(J), "some")
.withString(column(K), "smart")
.withString(column(N), "Programmer")
.withInteger(column(L), 1)
.withDate(column(P), createDate(11, FEBRUARY, 1979))
.withDouble(column(O), new Double("0.123456789"));
PoiWorkbook modified = new PoiWorkbook(getWorkbook("shouldAppendRowTemplate.xls")).appendRowToFirstSheet(row.build());
assertThat(modified.workbook(), sameWorkbook(getWorkbook("shouldAppendRowTemplateExpected.xls")));
}