• Home
• org.subtlelib
• poi.builder
• 1.0.4
• source code
• sample.txt

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

org.subtlelib.poi.api.row.sample.txt Maven / Gradle / Ivy

    /**
     * without conditional cell
            boolean isFirstRow = true;
            for (Entry condDiscRatesAndAmounts : condDiscRatesAndAmountsMap.entrySet()) {
                sheetContext
                    .nextRow();

                if (isFirstRow) {
                    sheetContext
                        .currentRow()
                            .skip()
                            .text(condName)
                            .skip(2);
                    
                    isFirstRow = false;
                } else {
                    sheetContext
                        .currentRow()
                            .skip(4);
                }

                
                sheetContext
                    .currentRow().withDefaultTextStyle(ExcelStyle.NUMBERS)
                        .percentage(condDiscRatesAndAmounts.getKey())
                        .formattedNumber(condDiscRatesAndAmounts.getValue() * -1);
            }
    * with conditional cell
            boolean isFirstRow = true;
            for (Entry condDiscRatesAndAmounts : condDiscRatesAndAmountsMap.entrySet()) {
                sheetContext
                    .nextRow()
                        .at(1).conditionalCell(isFirstRow).text(condName)
                        .withDefaultTextStyle(ExcelStyle.NUMBERS)
                        .at(4).percentage(condDiscRatesAndAmounts.getKey())
                        .formattedNumber(condDiscRatesAndAmounts.getValue() * -1);
                
                isFirstRow = false;
            }
     */