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

有个问题 xlsx格式不知道为什么日期格式转换有问题 #236

Open
Mrmore opened this issue Feb 26, 2024 · 3 comments
Open

有个问题 xlsx格式不知道为什么日期格式转换有问题 #236

Mrmore opened this issue Feb 26, 2024 · 3 comments

Comments

@Mrmore
Copy link

Mrmore commented Feb 26, 2024

xlsx格式不知道为什么日期格式转换有问题
333
2024年日历(纵向A4完美打印).xlsx

@Mrmore
Copy link
Author

Mrmore commented Feb 26, 2024

getCellText(cell) 函数 let {numFmt, value, type} = cell; 的问题 还是什么 我打印断点看了一下 workbookData 索引0 第一个标签 Sheet1 里面 没有type 属性 后面页脚的标签业里面的时间都显示正确

@501351981
Copy link
Owner

底层用的exceljs 读取之后没有看到单元格用的什么日期格式,可能要手动设置下单元格格式才行,我暂时也不知道怎么解决

@Mrmore
Copy link
Author

Mrmore commented Feb 27, 2024

简单用的exceljs读取之后看到没有单元格用的什么日期格式,可能要手动设置下单元格格式才行,我一时也不知道怎么解决

感谢 因为我没挂您的源码 就简单看了看 反应了一下这个问题 再次感谢

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants