@@ -0,0 +1,1752 @@
+package com.poiji.deserialize;%0A%0Aimport com.poiji.bind.Poiji;%0Aimport com.poiji.deserialize.model.byid.Calculation;%0Aimport com.poiji.option.PoijiOptions;%0Aimport org.junit.Test;%0Aimport org.junit.runner.RunWith;%0Aimport org.junit.runners.Parameterized;%0A%0Aimport java.io.File;%0Aimport java.time.LocalDate;%0Aimport java.time.format.DateTimeFormatter;%0Aimport java.time.format.DateTimeFormatterBuilder;%0Aimport java.time.temporal.ChronoField;%0Aimport java.util.Arrays;%0Aimport java.util.List;%0A%0Aimport static org.hamcrest.core.Is.is;%0Aimport static org.junit.Assert.assertThat;%0A%0A/**%0A * Created by hakan on 02/08/2018%0A */%0A@RunWith(Parameterized.class)%0Apublic class CalculationExcelTest %7B%0A%0A    private String path;%0A%0A    public CalculationExcelTest(String path) %7B%0A        this.path = path;%0A    %7D%0A%0A    @Parameterized.Parameters(name = %22%7Bindex%7D: (%7B0%7D)=%7B1%7D%22)%0A    public static Iterable%3CObject%5B%5D%3E queries() %7B%0A        return Arrays.asList(new Object%5B%5D%5B%5D%7B%0A                %7B%22src/test/resources/calculations.xlsx%22%7D,%0A        %7D);%0A    %7D%0A%0A    @Test%0A    public void shouldMapCalculations() %7B%0A%0A        final DateTimeFormatter formatter = new DateTimeFormatterBuilder()%0A                .appendPattern(%22M/d/%22)%0A                .appendValueReduced(ChronoField.YEAR_OF_ERA, 2, 2, LocalDate.now().minusYears(80)).toFormatter();%0A%0A        PoijiOptions options = PoijiOptions.PoijiOptionsBuilder.settings().sheetIndex(1).dateTimeFormatter(formatter).build();%0A%0A        List%3CCalculation%3E calculations = Poiji.fromExcel(new File(path), Calculation.class, options);%0A%0A        for (Calculation calculation : calculations) %7B%0A%0A            assertThat(calculation.getToDate().toString(), is(%222018-06-30%22));%0A            assertThat(calculation.getFromDate().toString(), is(%222018-01-01%22));%0A        %7D%0A    %7D%0A%7D%0A

add a test case for date time formatter