Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

功能-导出Excel:在表格中导出Date格式的数据时,时间不准确。 #666

Closed
2 tasks done
FrontEndDog opened this issue Jul 25, 2023 · 2 comments
Closed
2 tasks done
Labels
has workaround 有解决办法

Comments

@FrontEndDog
Copy link
Contributor

描述问题 (Describe the problem)

在导出excel时,如果带有Date格式的数据,在中国会多出43秒,时区如果在韩国,会多出52秒,其他时区未测试。

在excel.vue文件中50行添加一行代码:data[0]["column-0"] = new Date("2023/07/25 12:00:00");
image

如何复现该问题 (How to reproduce the problem)

复现仓库:https:/FrontEndDog/vue-pure-admin/tree/excel-recurrent
分支:excel-recurrent

操作系统和浏览器信息 (Operating system and browser information)

No response

验证 (Verify)

  • 是否仔细阅读过 文档 (Have you read documentation carefully)
  • 检查是否存在相同或类似的问题 issues (Check for the same or similar issues)
@xiaoxian521
Copy link
Member

xiaoxian521 commented Jul 25, 2023

非平台问题 自行研究xlsx 像你这种问题 大概率是你写法问题

FrontEndDog added a commit to FrontEndDog/vue-pure-admin that referenced this issue Jul 25, 2023
@FrontEndDog FrontEndDog mentioned this issue Jul 25, 2023
@xiaoxian521
Copy link
Member

xiaoxian521 commented Jul 26, 2023

解决办法之一: #668

xlsx 仅提供了免费的社区版本,很多功能受限,强烈推荐后端导出,因为无论从性能还是自定义方面,后端控制更为方便

@xiaoxian521 xiaoxian521 added the has workaround 有解决办法 label Jul 26, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
has workaround 有解决办法
Projects
None yet
Development

No branches or pull requests

2 participants