js/ts/tsx读取excel表格中的日期格式转换

const formatDate = (timestamp: number) => {
const time = new Date((timestamp - 1) * 24 * 3600000 + 1);
time.setFullYear(time.getFullYear() - 70);
const year = time.getFullYear();
const month = time.getMonth() + 1;
const date = time.getDate() - 1;
const format = '-';
return (
year + format + (month < 10 ? `0${month}` : month) + format + (date < 10 ? `0${date}` : date)
);
};