xlsx导入日期变为5位数字，转为正常日期

菜卷_

于 2022-11-26 16:16:23 发布

阅读量891

点赞数

文章标签： javascript 前端 typescript

本文链接：https://blog.youkuaiyun.com/fuxin199207/article/details/128053330

版权

// 5位数字日期转为正常日期
export const formatExcelDate = (numb, format = "-") => {
  const time = new Date((numb - 1) * 24 * 3600000 + 1);
  time.setYear(time.getFullYear() - 70);
  const year = time.getFullYear() + "";
  const month = time.getMonth() + 1 + "";
  const date = time.getDate() - 1 + "";
  if (format && format.length === 1) {
    return year + format + month + format + date;
  }
  return (
    year + (month < 10 ? "0" + month : month) + (date < 10 ? "0" + date : date)
  );
};