I am trying to export report as excel from dataset. The excel has header 'ORDER AGING REPORT' which should be bolder and center aligned to the child header. How I can set width at row label?
Here is my XSL
<xsl:stylesheet version="1.0" xmlns="urn:schemas-microsoft-
com:office:spreadsheet" xmlns:xsl="http://ift.tt/1xTKdRS
Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt"
xmlns:user="urn:my-scripts" xmlns:o="urn:schemas-microsoft-
com:office:office" xmlns:x="urn:schemas-microsoft- .
com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" >
<xsl:template match="NewDataSet">
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-
microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-
com:office:spreadsheet" xmlns:html="http://ift.tt/qQdaDR">
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11"
ss:Color="#000000"/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="Default2">
<Font ss:Bold="0" ss:FontName="Calibri" x:Family="Swiss"
ss:Size="9" ss:Color="#000000" />
<Borders>
<Border ss:Position="Left" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Top" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Right" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000"/>
<Border ss:Position="Bottom" ss:LineStyle="Continuous"
ss:Weight="1" ss:Color="#000000"/>
</Borders>
<Alignment ss:Horizontal="Center" ss:Vertical="Top"
ss:WrapText="1" />
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid" />
<NumberFormat ss:Format="General" />
</Style>
<Style ss:ID="titlehead" ss:Parent="Default2">
<Font ss:Bold="1" ss:FontName="Calibri" x:Family="Swiss" ss:Size="12" ss:Color="#121212" />
<Interior ss:Color="#99ccff" ss:Pattern="Solid" />
</Style>
<Style ss:ID="header" ss:Parent="Default2">
<Font ss:Bold="1" ss:FontName="Calibri" x:Family="Swiss"
ss:Size="11" ss:Color="#121212" />
<Interior ss:Color="#FFFFFF" ss:Pattern="Solid" />
</Style>
</Styles>
<Worksheet ss:Name="Summary">
<Table x:FullColumns="1" x:FullRows="1" ss:DefaultRowHeight="15">
<Column ss:AutoFitWidth="0" ss:Width="120"/>
<Column ss:AutoFitWidth="0" ss:Width="120"/>
<Column ss:AutoFitWidth="0" ss:Width="120"/>
<Column ss:AutoFitWidth="0" ss:Width="120"/>
<Column ss:AutoFitWidth="0" ss:Width="120"/>
<Column ss:AutoFitWidth="0" ss:Width="120"/>
<Row>
<Cell ss:StyleID="titlehead">
<Data ss:Type="String">ORDER AGING REPORT</Data>
</Cell>
</Row>
<Row>
<Cell ss:StyleID="header">
<Data ss:Type="String">Age</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Parts Request (PR)</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Ship Request(SR)</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Exchange(EX)</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Regular(01)</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Transfer(33)</Data>
</Cell>
</Row>
<xsl:apply-templates select="Table1"/>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<Selected/>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Detail">
<Table x:FullColumns="1" x:FullRows="1" ss:DefaultRowHeight="25">
<Column ss:AutoFitWidth="0" ss:Width="85"/>
<Column ss:AutoFitWidth="0" ss:Width="85"/>
<Column ss:AutoFitWidth="0" ss:Width="60"/>
<Column ss:AutoFitWidth="0" ss:Width="185"/>
<Column ss:AutoFitWidth="0" ss:Width="185"/>
<Column ss:AutoFitWidth="0" ss:Width="60"/>
<Column ss:AutoFitWidth="0" ss:Width="75"/>
<Column ss:AutoFitWidth="0" ss:Width="75"/>
<Column ss:AutoFitWidth="0" ss:Width="60"/>
<Column ss:AutoFitWidth="0" ss:Width="70"/>
<Column ss:AutoFitWidth="0" ss:Width="70"/>
<xsl:apply-templates select="Header"/>
<Row>
<Cell ss:StyleID="header">
<Data ss:Type="String">Order Number</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Ticket Number</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Order Type</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Customer Name</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Customer Address</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Pick Status</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Batch Number</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">BOL Number</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">SCAC Code</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Add Date</Data>
</Cell>
<Cell ss:StyleID="header">
<Data ss:Type="String">Add Time</Data>
</Cell>
</Row>
<xsl:apply-templates select="Table_2"/>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
</PageSetup>
<Selected/>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>
</xsl:template>
<xsl:template match="Table1" >
<Row>
<Cell>
<Data ss:Type="String">
<b> 1 Day</b>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="PR_COUNT_DAY_ONE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="SR_COUNT_DAY_ONE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="EX_COUNT_DAY_ONE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="RE_COUNT_DAY_ONE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="TR_COUNT_DAY_ONE"/>
</Data>
</Cell>
</Row >
<Row>
<Cell>
<Data ss:Type="String">
<b> 2 Day</b>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="PR_COUNT_DAY_TWO"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="SR_COUNT_DAY_TWO"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="EX_COUNT_DAY_TWO"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="RE_COUNT_DAY_TWO"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="TR_COUNT_DAY_TWO"/>
</Data>
</Cell>
</Row >
<Row>
<Cell>
<Data ss:Type="String">
<b> 3 Day</b>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="PR_COUNT_DAY_THREE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="SR_COUNT_DAY_THREE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="EX_COUNT_DAY_THREE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="RE_COUNT_DAY_THREE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="TR_COUNT_DAY_THREE"/>
</Data>
</Cell>
</Row >
<Row>
<Cell>
<Data ss:Type="String">
<b> 4 Day</b>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="PR_COUNT_DAY_FOUR"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="SR_COUNT_DAY_FOUR"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="EX_COUNT_DAY_FOUR"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="RE_COUNT_DAY_FOUR"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="TR_COUNT_DAY_FOUR"/>
</Data>
</Cell>
</Row >
<Row>
<Cell>
<Data ss:Type="String">
<b> >5 Day</b>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="PR_COUNT_DAY_FIVE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="SR_COUNT_DAY_FIVE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="EX_COUNT_DAY_FIVE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="RE_COUNT_DAY_FIVE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="TR_COUNT_DAY_FIVE"/>
</Data>
</Cell>
</Row >
</xsl:template >
<xsl:template match="Table_2">
<Row>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="ORDER_NUMBER"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="Number">
<xsl:value-of select="TICKET_NUMBER"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="ORDER_TYPE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="CUSTOMER_NAME"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="CUSTOMER_ADDRESS"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="PICK_STATUS"/>
</Data>
</Cell>
<Cell >
<Data ss:Type="Number">
<xsl:value-of select="LABEL_BATCH_NUMBER"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="BOL_NUMBER"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:value-of select="CLIENT_SCAC_CODE"/>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:if test="ADD_DATE != ''">
<xsl:value-of select="concat(substring(ADD_DATE, 6, 2), '/',substring(ADD_DATE, 9, 2), '/', substring(ADD_DATE, 1, 4))"/>
</xsl:if>
</Data>
</Cell>
<Cell>
<Data ss:Type="String">
<xsl:if test="ADD_TIME != ''">
<xsl:value-of select="substring(ADD_TIME, 12, 8)"/>
</xsl:if>
</Data>
</Cell>
</Row >
</xsl:template >
</xsl:stylesheet>
Required as
No comments:
Post a Comment