如何在VB.Net中包装/解包Excel中的文本

时间:2021-02-14 14:02:24

Please help me to wrap/unwrap text in excel using vb.net with the following code:

请帮助我使用vb.net使用以下代码在excel中打包/解包文本:

Dim excelDoc as stringBuilder excelDoc.Append("") excelDoc.Append(" " & "I am Jewel. Bangladesh is my country") excelDoc.Append("")

将excelDoc变暗为stringBuilder excelDoc.Append(“”)excelDoc.Append(“”“我是宝石。孟加拉国是我的国家”)excelDoc.Append(“”)

1 个解决方案

#1


0  

it can be solved using ss:WrapText=""1"" to wrap and ss:WrapText=""0"" to unwrap which should be use in Alignment like this:

它可以使用ss来解决:WrapText =“”1“”来换行和ss:WrapText =“”0“”解开哪些应该在Alignment中使用,如下所示:

<Alignment ss:Horizontal=""Left"" ss:Vertical=""Center"" ss:WrapText=""0""/>

#1


0  

it can be solved using ss:WrapText=""1"" to wrap and ss:WrapText=""0"" to unwrap which should be use in Alignment like this:

它可以使用ss来解决:WrapText =“”1“”来换行和ss:WrapText =“”0“”解开哪些应该在Alignment中使用,如下所示:

<Alignment ss:Horizontal=""Left"" ss:Vertical=""Center"" ss:WrapText=""0""/>