v0.3.2

Add ExcelPointer isFormula() property.

Example

public class SomeDto {
    @ExcelPoint(value="D4", isFormula = true)
    private String formula = "SUMIF(B2:B25,\">5\")";
}

• modify dependencies build option

Full Changelog: v0.3.1...v0.3.2

v0.3.1

💊 Bug Fix

• 스프링에서 구동 시 multiple-slf4j 이슈 해결

Full Changelog: v0.2.5...v0.3.1

v0.3.0

🌈 Build Bug Fix

1. add Slf4j implement library

v0.2.4

🔥 Feature

1. MapPointExcelWriter 기능 추가.
2. lombok 의존성 삭제

🚀 How To Use

@Controller
@Slf4j
public class ExcelController {

    @GetMapping(value = "/mapper/excel/map")
    public void mapperExcelDownload(HttpServletResponse response) throws IOException {
        String originExcelFilePath = this.baseProjectFilePath + File.separator + "excel" + File.separator + "sample1.xlsx";
        Map<String, String> data = new HashMap<>();
        data.put("name", "홍길동1");
        data.put("age", "10");
        data.put("hp", "010-1234-1234");
        PointExcelWriter<Map> mapPointExcelWriter = new MapPointExcelWriter();
        mapPointExcelWriter.setInputStream(new FileInputStream(originExcelFilePath));
        mapPointExcelWriter.setData(data);
        mapPointExcelWriter.download(response, "맵_포인트_엑셀_라이터.xlsx");
    }
}

What's Changed

• Styles/remove lombok by @BBackJK in #3

Full Changelog: v0.2.3...v0.2.4

v0.2.4-alpha

🔥 feat : Map Point Excel Writer 추가

• Reflect 가 아닌 Map<String, String> 을 이용한 Writer 추가

Full Changelog: v0.2.3...v0.2.4-alpha

v0.2.3

🔥 Add Feature List Grid Excel Writer

how to use

@Controller
public class ExcelController {

    @GetMapping(value = "/member/excel/list")
    public void listExcelDownload(HttpServletResponse response) {
        List<List<String>> header = new ArrayList<>();
        List<String> headerRow = new ArrayList<>();
        headerRow.add("헤더1");
        headerRow.add("헤더2");
        headerRow.add("헤더3");
        headerRow.add("헤더4");
        header.add(headerRow);


        List<List<Object>> body = new ArrayList<>();
        int loopCount = 4;
        for (int i=0; i<loopCount;i++) {
            List<Object> bodyRow = new ArrayList<>();
            bodyRow.add((i+1) + "-바디1");
            bodyRow.add((i+1) + "-바디2");
            bodyRow.add((i+1) + "-바디3");
            bodyRow.add((i+1) + "-바디4");
            body.add(bodyRow);
        }

        GridExcelWriter<List<Object>> temp = new ListGridExcelWriter(header);
        temp.setDataList(body);
        temp.download(response, "리스트_그리드_엑셀_라이터.xlsx");
    }
}

What's Changed

• Feat/listgridexcel by @BBackJK in #2

Full Changelog: v0.1.0...v0.2.3

v0.2.3-alpha

💊 ListGridExcelWriter write body method 수정

• writeBody abstract method implement contents fixed.

changelog

• add only header constructure

Full Changelog: v0.2.2-alpha...v0.2.3-alpha

v0.2.2-alpha

💊 List Grid Excel Writer 생성자 접근제어자 수정

v0.2.1-alpha

💊 MapExcelReader Generic cast 버그 수정

Full Changelog: v.0.2.0-alpha...v.0.2.1-alpha

v0.2.0-alpha

🔥 list grid excel writer 기능 추가 및 테스트

Full Changelog: v0.1.0...v.0.2.0-alpha