@Override
public void onActivityResult(int requestCode, int resultCode, Intent data) {
super.onActivityResult(requestCode, resultCode, data);
// 导入Excel
if (requestCode == REQUEST_FILE_PATH && resultCode == RESULT_OK) {
excelHandler.readWorkBook(data.getStringExtra("URL"));
if (excelHandler.openSucceed()) {
Intent intent = new Intent(MainActivity.this, FirstActivity.class);
startActivity(intent);
}
}
}
/**
* 创建单元格样式
*
* @param fontColor 字体颜色
* @param fontBlod 字体加粗值
* @param fontUnderLine 字体下划线
* @param fontSize 字体大小
* @param fontAlign 字体对齐方式
* @param isBorder 单元格是否带边框
* @return
*/
public static CellStyle newInstance(
ExcelHandler handler,
short fontColor,
short fontBlod,
byte fontUnderLine,
short fontSize,
short fontAlign,
boolean isBorder) {
return newInstance(
handler.getWorkbook(), fontColor, fontBlod, fontUnderLine, fontSize, fontAlign, isBorder);
}
@Test
public void testReadFixedRows() throws Exception {
ExcelRange range = ExcelRange.sheetIndex(0).rowFrom(1).rowTo(2).columnRange("A", "G");
ExcelRangeData data = instance.readRange(range);
assertEquals(2, data.getRowCount());
assertEquals("suilink", data.getString(0, 0));
assertEquals("广州穗灵通讯科技有限公司", data.getString(0, 1));
assertTrue(DateUtils.isSameDay(data.getDate(0, 2), parseDate(2002, 7, 1)));
assertNull(data.getDate(0, 3));
assertEquals(1, data.getInt(0, 4).intValue());
assertEquals(1L, data.getLong(0, 4).longValue());
assertEquals(1.0, data.getDouble(0, 4).doubleValue(), 0.0001);
assertNull(data.getDate(0, 5));
assertFalse(data.getBoolean(0, 6));
assertTrue(data.getBoolean(1, 6));
}
@Test(expected = IllegalStateException.class)
public void testWrongDate() {
ExcelRange range = ExcelRange.sheetIndex(0).rowFrom(1).rowTo(2).columnRange("A", "G");
ExcelRangeData data = instance.readRange(range);
data.getDate(0, 1);
}
