Skip to content

Latest commit

 

History

History
187 lines (143 loc) · 5.51 KB

README.md

File metadata and controls

187 lines (143 loc) · 5.51 KB
Raw

choodon-excel

  • a simple excel generator

Developer

Apache Maven Dependency

<dependency>
  <groupId>com.choodon.tool</groupId>
  <artifactId>choodon-excel</artifactId>
  <version>1.0.6-RELEASE</version>
</dependency>

Demo

/**
 * Copyright [2019] [choodon-excel of copyright https://github.com/choodon account owner]
 * <p>
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * <p>
 * http://www.apache.org/licenses/LICENSE-2.0
 * <p>
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * <p>
 */

import com.choodon.tool.excel.Convert;

public class DemoConvert implements Convert<Double> {

    @Override
    public String convert(Double data) {
        if (data == -1) {
            return "无限制";
        }
        return data.toString();
    }
}
/**
 * Copyright [2019] [choodon-excel of copyright https://github.com/choodon account owner]
 * <p>
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * <p>
 * http://www.apache.org/licenses/LICENSE-2.0
 * <p>
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * <p>
 */

import com.choodon.tool.excel.util.NumberUtils;

public enum DemoEnum {
    /**
     * enum
     */
    FFF;

    private static String desc(Number number) {
        if (NumberUtils.equals(number, 1)) {
            return "enum1";
        }
        if (NumberUtils.equals(number, 2)) {
            return "enum2";
        }
        return "";
    }

}
/**
 * Copyright [2019] [choodon-excel of copyright https://github.com/choodon account owner]
 * <p>
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * <p>
 * http://www.apache.org/licenses/LICENSE-2.0
 * <p>
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 * <p>
 */


import com.choodon.tool.excel.Excel;
import com.choodon.tool.excel.anotation.Column;
import com.choodon.tool.excel.anotation.Header;
import com.choodon.tool.excel.enums.DataFormat;
import com.choodon.tool.excel.enums.Operation;

import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

@Header("test")
public class Demo {

    @Column(name = "strPlain")
    private String plain = "hello";

    @Column(name = "numPlain")
    private int numPlain = 8;

    @Column(name = "date", format = DataFormat.DATE_TIME, dateTimeFormat = "yyyy-MM-dd")
    private Date date = new Date();

    @Column(name = "date_time", format = DataFormat.DATE_TIME)
    private Date date_time = new Date();


    @Column(name = "money_fen_2_yuan_without_scale", format = DataFormat.NUMBER, operation = Operation.DIVIDE, operationNumber = 100, scale = 0)
    private Long money_fen_2_yuan_without_scale = 123456789L;

    @Column(name = "money_fen_2_yuan_with_2_scale", format = DataFormat.NUMBER, operation = Operation.DIVIDE, operationNumber = 100, scale = 2)
    private Long money_fen_2_yuan_with_2_scale = 123456789L;


    @Column(name = "money_fen_2_yuan_with_comma", format = DataFormat.NUMBER, operation = Operation.DIVIDE, operationNumber = 100, scale = 0, numberFormat = "#,##0")
    private Long money_fen_2_yuan_with_comma_without_scale = 123456789L;

    @Column(name = "money_fen_2_yuan_with_comma_round_half_up", format = DataFormat.NUMBER, operation = Operation.DIVIDE, operationNumber = 100, scale = 0, roundingMode = BigDecimal.ROUND_HALF_UP, numberFormat = "#,##0")
    private Long money_fen_2_yuan_with_comma_with_2_scale = 123456789L;

    @Column(name = "percentage", format = DataFormat.NUMBER, numberFormat = "##0.00%")
    private Double percentage = 0.1344;

    @Column(name = "enum", format = DataFormat.ENUM, enumClass = DemoEnum.class)
    private Number enumX = 1;

    @Column(name = "convert", format = DataFormat.CUSTOM, convertClass = DemoConvert.class)
    private Double convert = -1D;


    public static void main(String[] args) throws IOException {
        List<Demo> demoList = new ArrayList();
        demoList.add(new Demo());

        String tableName = Excel.getTableName(Demo.class);
        byte[] bytes = Excel.create(Demo.class, demoList);

        //test.xlsx
        File file = new File(tableName + ".xlsx");

        try (FileOutputStream fileOutputStream = new FileOutputStream(file)) {
            fileOutputStream.write(bytes);
            fileOutputStream.flush();
        }
    }
}