com.litongjava.table.convert.LocalDateTimeConverter Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of api-table Show documentation

auto curd for db table

There is a newer version: 1.4.8

package com.litongjava.table.convert;

import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;

import com.alibaba.excel.converters.Converter;
import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.metadata.CellData;
import com.alibaba.excel.metadata.GlobalConfiguration;
import com.alibaba.excel.metadata.property.ExcelContentProperty;

public class LocalDateTimeConverter implements Converter {

  @Override
  public Class supportJavaTypeKey() {
    return LocalDateTime.class;
  }

  @Override
  public CellDataTypeEnum supportExcelTypeKey() {
    return CellDataTypeEnum.STRING;
  }

  @Override
  public LocalDateTime convertToJavaData(@SuppressWarnings("rawtypes") CellData cellData,
      ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception {
    DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
    String stringValue = cellData.getStringValue();
    return LocalDateTime.parse(stringValue, formatter);
  }

  @Override
  public CellData convertToExcelData(LocalDateTime value, ExcelContentProperty contentProperty,
      GlobalConfiguration globalConfiguration) throws Exception {
    DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
    String formattedValue = value.format(formatter);
    return new CellData<>(formattedValue);
  }

}