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

你好,请问如何处理复杂表头的导出? #2

Open
wangce123 opened this issue Aug 4, 2021 · 0 comments
Open

你好,请问如何处理复杂表头的导出? #2

wangce123 opened this issue Aug 4, 2021 · 0 comments

Comments

@wangce123
Copy link

wangce123 commented Aug 4, 2021

一开始我采用的是:获取table的dom,table_to_sheet然后book_append_sheet是可以导出复杂表头的excel的;
后来由于需要调整导出excel的样式,第一行添加大标题,然后找到了您封装的这个,您的excelExport接受参数data和title,
于是我table_to_sheet之后用sheet_to_json然后再组装成您备注的data格式(数据格式为 第一行是 小标题 后续行则是对应行数据),对于普通的表格没有问题,但是复杂表头的表格就会导出含有“__EMPTY”“__EMPTY_2”等;
请问有办法解决吗?

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

1 participant