Geek asks and answers

Show multiline text value in cells of Excel excel document made using C # XmlWriter

Situation: I am creating C # .Net 4.0 Winform to collect data from an Oracle database using filters selected by the user and putting them into the Gridview preview for validation. Once they filter the data to their liking, they click the export button, which converts the datatable to an XML document, which opens in Excel with a double click. Inside an excel excel file, each entry looks like this:

  <ss:Row>
    <ss:Cell ss:StyleID="General">
      <ss:Data ss:Type="String">110002</ss:Data>
    </ss:Cell>
    <ss:Cell ss:StyleID="General">
      <ss:Data ss:Type="String">GALV.047M X 3 G90 A653 PASSDRY SQ GR33</ss:Data>
    </ss:Cell>
    <ss:Cell ss:StyleID="General">
      <ss:Data ss:Type="String">.047 MIN X 3 X COIL
!GALV G90 ASTM A 653 SQ GR33 PASS DRY*

20" ID
5 TON MAX LIFT
SKID EYE TO THE SKY
3" X 3" SPACER IN BETWEEN EACH BUNDLE
SUPPLY TEST REPORTS CHEMICAL</ss:Data>
    </ss:Cell>
  </ss:Row>

excel, , , CVS, . , XML , excel , , (.. , ).

: XML , (, , ), XML ?

+3
1

Excel XML, :

<Style ss:ID="s62">
   <Alignment ss:Vertical="Bottom" ss:WrapText="1"/>
</Style>

Cell XML:

<Cell ss:StyleID="s62"> <Data ss:Type="String">First Line&#10;Second Line&#10;Last Line</Data> </Cell>

+4

More articles:


All Articles