/**
* This should test to see if a cell is in a certain range or not. If it is in a merged range,
* then it should return the top left cell.
*
* @throws Exception
*/
public void testCellMerge() throws Exception {
ExcelParser parser = new ExcelParser((Map) null);
Range[] ranges = new Range[1];
MockRange r1 = new MockRange();
ranges[0] = r1;
r1.topLeft = new MockCell();
r1.topLeft.row = 2;
r1.topLeft.column = 2;
r1.topLeft.contents = "first";
r1.bottomRight = new MockCell();
r1.bottomRight.column = 5;
r1.bottomRight.row = 7;
r1.bottomRight.contents = "last";
MockCell cell = new MockCell();
cell.contents = "test";
cell.row = 1;
cell.column = 1;
assertNull(parser.getRangeIfMerged(cell, ranges));
cell = new MockCell();
cell.contents = "wrong";
cell.row = 2;
cell.column = 5;
assertEquals("first", parser.getRangeIfMerged(cell, ranges).getTopLeft().getContents());
}
public void testRemoveTrailingZero() {
String test = "1.0";
assertEquals("1", ExcelParser.removeTrailingZero(test));
test = "42.0";
assertEquals("42", ExcelParser.removeTrailingZero(test));
test = "42";
assertEquals("42", ExcelParser.removeTrailingZero(test));
}
@Override
public void setParser(String filePath, String dateString) {
super.initParser(filePath);
currentDate = DateUtils.getDateByString(dateString, "yyyyMMdd");
}
