xml bi publisher導出EXCEL欄位格式為日期如何設置？

wangtianwei18

xml bi publisher導出EXCEL欄位格式為日期如何設置？每次導出欄位都是通用格式，利用BI PUBLISHER格式化也達不到要求，還是我沒有設置對？請高手指教～

topsen

同问哦

wangtianwei18

誒，感嘆，一個問題問倒一群英雄漢～！！！

wndemon

1. 
   
2. <?xml version="1.0"?>
   
3. <?mso-application progid="Excel.Sheet"?>
   
4. <Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
   
5. xmlns:o="urn:schemas-microsoft-com:office:office"
   
6. xmlns:x="urn:schemas-microsoft-com:office:excel"
   
7. xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
   
8. xmlns:html="http://www.w3.org/TR/REC-html40">
   
9. <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
   
10.   <Author>Admin</Author>
    
11.   <LastAuthor>Admin</LastAuthor>
    
12.   <Created>2011-08-11T07:25:35Z</Created>
    
13.   <Version>12.00</Version>
    
14. </DocumentProperties>
    
15. <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
    
16.   <WindowHeight>12210</WindowHeight>
    
17.   <WindowWidth>17055</WindowWidth>
    
18.   <WindowTopX>240</WindowTopX>
    
19.   <WindowTopY>15</WindowTopY>
    
20.   <ProtectStructure>False</ProtectStructure>
    
21.   <ProtectWindows>False</ProtectWindows>
    
22. </ExcelWorkbook>
    
23. <Styles>
    
24.   <Style ss:ID="Default" ss:Name="Normal">
    
25.    <Alignment ss:Vertical="Center"/>
    
26.    <Borders/>
    
27.    <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
    
28.    <Interior/>
    
29.    <NumberFormat/>
    
30.    <Protection/>
    
31.   </Style>
    
32.   <Style ss:ID="s62">
    
33.    <NumberFormat ss:Format="Short Date"/>
    
34.   </Style>
    
35. </Styles>
    
36. <Worksheet ss:Name="Sheet1">
    
37.   <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="4" x:FullColumns="1"
    
38.    x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5">
    
39.    <Column ss:Index="2" ss:Width="57"/>
    
40.    <Row ss:Index="4">
    
41.     <Cell ss:Index="2" ss:StyleID="s62"><Data ss:Type="DateTime">2011-01-02T00:00:00.000</Data></Cell>
    
42.    </Row>
    
43.   </Table>
    
44.   <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
    
45.    <PageSetup>
    
46.     <Header x:Margin="0.3"/>
    
47.     <Footer x:Margin="0.3"/>
    
48.     <PageMargins x:Bottom="0.75" x:Left="0.7" x:Right="0.7" x:Top="0.75"/>
    
49.    </PageSetup>
    
50.    <Print>
    
51.     <ValidPrinterInfo/>
    
52.     <PaperSizeIndex>0</PaperSizeIndex>
    
53.     <VerticalResolution>0</VerticalResolution>
    
54.     <NumberofCopies>0</NumberofCopies>
    
55.    </Print>
    
56.    <Selected/>
    
57.    <Panes>
    
58.     <Pane>
    
59.      <Number>3</Number>
    
60.      <ActiveRow>3</ActiveRow>
    
61.      <ActiveCol>1</ActiveCol>
    
62.     </Pane>
    
63.    </Panes>
    
64.    <ProtectObjects>False</ProtectObjects>
    
65.    <ProtectScenarios>False</ProtectScenarios>
    
66.   </WorksheetOptions>
    
67. </Worksheet>
    
68. </Workbook>
    

复制代码

wndemon

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-comffice: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://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>Admin</Author>
  <LastAuthor>Admin</LastAuthor>
  <Created>2011-08-11T07:25:35Z</Created>
  <Version>12.00</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>12210</WindowHeight>
  <WindowWidth>17055</WindowWidth>
  <WindowTopX>240</WindowTopX>
  <WindowTopY>15</WindowTopY>
  <rotectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Center"/>
   <Borders/>
   <Font ss:FontName="宋体" x:CharSet="134" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s62">
   <NumberFormat ss:Format="Short Date"/>
  </Style>
</Styles>
<Worksheet ss:Name="Sheet1">
  <Table ss:ExpandedColumnCount="2" ss:ExpandedRowCount="4" x:FullColumns="1"
   x:FullRows="1" ss:DefaultColumnWidth="54" ss:DefaultRowHeight="13.5">
   <Column ss:Index="2" ss:Width="57"/>
   <Row ss:Index="4">
    <Cell ss:Index="2" ss:StyleID="s62"><Data ss:Type="DateTime">2011-01-02T00:00:00.000</Data></Cell>
   </Row>
  </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" xeft="0.7" x:Right="0.7" x:Top="0.75"/>
   </PageSetup>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>0</PaperSizeIndex>
    <VerticalResolution>0</VerticalResolution>
    <NumberofCopies>0</NumberofCopies>
   </Print>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>3</ActiveRow>
     <ActiveCol>1</ActiveCol>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
</Worksheet>
</Workbook>

wndemon

你是用rtf做模板？那不是在属性那里可以设置么：

wangtianwei18

wndemon 发表于 2011/8/12 09:03
你是用rtf做模板？那不是在属性那里可以设置么：

這個設置根本沒有用的，例如我在那個地方設置格式為DATE型 然后格式化為YYYY-MM-DD 這樣，導出來的EXCEL文檔格式根本沒有變化～

wndemon

wangtianwei18 发表于 2011/9/5 09:37
這個設置根本沒有用的，例如我在那個地方設置格式為DATE型 然后格式化為YYYY-MM-DD 這樣，導出來的EXCEL文 ...

那你就改用上面的XSL制作模板，这个可以很灵活的操作生成的excle。。