该博客探讨了如何在Excel单元格中插入包含HTML格式（颜色、粗体、斜体等）且保留换行符的文本。作者遇到的问题是，当文本包含换行符时，Excel会将它们分开成不同的单元格。通过使用mso-data-placement:same-cell样式并未得到预期效果。解决方案是利用System.Text.StringBuilder对象构建字符串，并在VBA代码中使用Paste方法，成功实现了在单个单元格内保持格式和换行。
I'm trying to insert HTML/RTF formatted text into a single Excel cell, preserving text formatting (colour, bold, italic etc.).
The problem is that if the text contains line breaks (
), parts of the text between the breaks is inserted into separate cells.
I tried , but it seems to be ignored by Excel's parser and treated like a normal
.
A lot of topics on forums say that mso-data-placement:same-cell lets you have new line breaks inside a cell, but in my case this style is ignored.
How do I achieve text formatting and line breaks when pasting text into a single cell?
My code (simplified a bit):
Private Sub Worksheet_Change2(ByVal Target As Range, ByVal sht As Worksheet)
最低0.47元/天 解锁文章
扫一扫
682
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
