Salve a tutti, ho la necessità di creare una tabella in un file XSL che mi permetta di generare un file excel tramite PL/SQL.. Per quanto riguarda una tabella semplice, riesco benissimo a farlo.. Il problema si presenta quando voglio inserire i dati nella tabella utilizzando prima tutta una colonna e successivamente un'altra colonna.. Con la mia soluzione le due colonne risultano sfalsate (dove finisce una inizia l'altra) mentre io voglio che le due colonne inizino a partire dalla stessa riga.. Non so se ho reso l'idea.. In ogni caso sotto riporto il pezzo di codice della tabella..
<Table ss:ExpandedColumnCount="9" x:FullColumns="1"
x:FullRows="1" ss:StyleID="s21">
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="120"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="200"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="80"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="100"/>
<Column ss:StyleID="s21" ss:AutoFitWidth="0" ss:Width="100"/>
<xsl:for-each select="HEADER">
<Row ss:AutoFitHeight="0" ss:Height="34.5">
<Cell ss:StyleID="s22"><Data ss:Type="String">Societa</Data></Cell>
<Cell ss:StyleID="s22"><Data ss:Type="String">Fornitore</Data></Cell>
<Cell ss:StyleID="s22"><Data ss:Type="String">Numero Fornitore</Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"></Data></Cell>
</Row>
</xsl:for-each>
<xsl:for-each select="LINE">
<Row>
<Cell ss:StyleID="s23"><Data ss:Type="String"><xsl:value-of select="SOCIETA"/></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><xsl:value-of select="FORNITORE"/></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><xsl:value-of select="NUMERO_FORNITORE"/></Data></Cell>
</Row>
</xsl:for-each>
<xsl:for-each select="LINE1">
<Row>
<Cell ss:StyleID="s23"><Data ss:Type="String"><xsl:value-of select="NUMERO_FATTURA_5"/></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><xsl:value-of select="DATA_FATTURA_5"/></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><xsl:value-of select="DATA_GL_5"/></Data></Cell>
</Row>
</xsl:for-each>
<xsl:for-each select="LINE2">
<Row>
<Cell ss:StyleID="s23"><Data ss:Type="String"><xsl:value-of select="NUMERO_FATTURA_4"/></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><xsl:value-of select="DATA_FATTURA_4"/></Data></Cell>
<Cell ss:StyleID="s23"><Data ss:Type="String"><xsl:value-of select="DATA_GL_4"/></Data></Cell>
</Row>
</xsl:for-each>
</Table>
Grazie Mille..

Rispondi quotando