Style for wrapped text using a table

I create my table using xslt and want a cell with wrapped text (or better: text with a line break in it).

So my xslt generates the following XML for sheets:

<sheetData>
  <row r="1">
    <c r="A1" t="inlineStr">
      <is>
        <t>
          a simple string
          line break jeeeehaaa
        </t>
      </is>
    </c>
  </row>
</sheetData>

After I finished creating my book, I will open it in Excel; and there is no line break, just a simple single line line in A1.

Anyone have a solution? No need to be in xml or xslt (but it would be nice). I could also do some things in C #
+3
source share
1 answer

excel , , style.xml. , style.xml, <c r="A1" t="inlineStr"> '( ). , .

excel , .

sheet.xml, <c> s="1" -.

, style.xml , <cellXfs> <xf>, <alignment> wrapText "1" ( "" ).

, SO. , :)

+4

All Articles