从 Excel 文档在 Word 中自动创建表格
我在 Excel 中有一组数据,如下所示(CSV 格式),
heading1, heading2, heading3, index
A , randomdata1, randomdata2, 1
A , randomdata1, randomdata2, 2
A , randomdata1, randomdata2, 3
B , randomdata1, randomdata2, 4
C , randomdata1, randomdata2, 5
我希望能够自动构建一个 Word 文档来显示这些数据,其中信息按标题 1 分组到单独的表中。所以文档这个词就像“
Table A
heading1, heading2, heading3, index
A , randomdata1, randomdata2, 1
A , randomdata1, randomdata2, 2
A , randomdata1, randomdata2, 3
Table B
heading1, heading2, heading3, index
B , randomdata1, randomdata2, 4
Table C
heading1, heading2, heading3, index
C , randomdata1, randomdata2, 5
请有人帮我解决这个问题”,因为它将节省大约 20 个小时非常无聊的复制和打印时间。粘贴并格式化!
感谢您的帮助
I have a set of data in Excel which is like the below (in CSV format)
heading1, heading2, heading3, index
A , randomdata1, randomdata2, 1
A , randomdata1, randomdata2, 2
A , randomdata1, randomdata2, 3
B , randomdata1, randomdata2, 4
C , randomdata1, randomdata2, 5
I want to be able to auto build a word document that presents this data, which the information grouped by heading1, into separate tables. So the word document would be like
Table A
heading1, heading2, heading3, index
A , randomdata1, randomdata2, 1
A , randomdata1, randomdata2, 2
A , randomdata1, randomdata2, 3
Table B
heading1, heading2, heading3, index
B , randomdata1, randomdata2, 4
Table C
heading1, heading2, heading3, index
C , randomdata1, randomdata2, 5
Please could someone help me with this as it will save about 20 hours of very boring copy & pasting and formatting!
Thanks for any help
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
多丽,
希望这能及时提供帮助。
为此,您需要设置对 Word 的引用 - 在 VBA 编辑器中选择“工具”>“引用”并向下滚动到 Microsoft Word ##,其中 ## 对于 Excel '07 为 12.0,对于 Excel '03 为 11.0,等等。另外,当您运行此命令时,不应过滤工作表,尽管您不需要按标题 1 排序,但我假设您已经这样做了。
该代码假定您的列表以单元格 A1 中的标题开始。如果这不是真的,你应该这样做。它还假定 D 中的最后一列。您可以在以“.Copy”开头的行末尾调整该值。
Dori,
Hope this is in time to help.
For this to work you need to set a reference to Word - in the VBA editor choose Tools>References and scroll down to Microsoft Word ##, where ## is 12.0 for Excel '07, 11.0 for Excel '03, etc. Also, the sheet shouldn't be filtered when you run this, and although you don't need to sort by heading 1, I assumed that you have.
The code assumes that your list starts with header in cell A1. IF that's not true you should make it so. It also assumes that your last column in D. You can adjust that in the line towards the end that starts with ".Copy".