2 u013047803 u013047803 于 2016.02.26 16:20 提问

【小白求助】excel问题 4C
 <?xml version="1.0" encoding="utf-8"?>
<ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoftcom:office:office">
<o:DocumentProperties>
    <o:Title>用户使用机型及人数</o:Title>
</o:DocumentProperties>
<ss:ExcelWorkbook>
    <ss:WindowHeight>9000</ss:WindowHeight>
    <ss:WindowWidth>34550</ss:WindowWidth>
    <ss:ProtectStructure>False</ss:ProtectStructure>
    <ss:ProtectWindows>False</ss:ProtectWindows>
</ss:ExcelWorkbook>
<ss:Styles>
    <ss:Style ss:ID="Default">
        <ss:Alignment ss:Vertical="Top"  />
        <ss:Font ss:FontName="arial" ss:Size="10" />
        <ss:Borders>
            <ss:Border  ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Top" />
            <ss:Border  ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Bottom" />
            <ss:Border  ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Left" />
            <ss:Border ss:Weight="1" ss:LineStyle="Continuous" ss:Position="Right" />
        </ss:Borders>
        <ss:Interior />
        <ss:NumberFormat />
        <ss:Protection />
    </ss:Style>
    <ss:Style ss:ID="title">
        <ss:Borders />
        <ss:Font />
        <ss:Alignment  ss:Vertical="Center" ss:Horizontal="Center" />
        <ss:NumberFormat ss:Format="@" />
    </ss:Style>
    <ss:Style ss:ID="headercell">
        <ss:Font ss:Bold="1" ss:Size="10" />
        <ss:Alignment  ss:Horizontal="Center" />
        <ss:Interior ss:Pattern="Solid"  />
    </ss:Style>
    <ss:Style ss:ID="even">
        <ss:Interior ss:Pattern="Solid" />
    </ss:Style>
    <ss:Style ss:Parent="even" ss:ID="evendate">
        <ss:NumberFormat ss:Format="yyyy-mm-dd" />
    </ss:Style>
    <ss:Style ss:Parent="even" ss:ID="evenint">
        <ss:NumberFormat ss:Format="0" />
    </ss:Style>
    <ss:Style ss:Parent="even" ss:ID="evenfloat">
        <ss:NumberFormat ss:Format="0.00" />
    </ss:Style>
    <ss:Style ss:ID="odd">
        <ss:Interior ss:Pattern="Solid"  />
    </ss:Style>
    <ss:Style ss:Parent="odd" ss:ID="odddate">
        <ss:NumberFormat ss:Format="yyyy-mm-dd" />
    </ss:Style>
    <ss:Style ss:Parent="odd" ss:ID="oddint">
        <ss:NumberFormat ss:Format="0" />
    </ss:Style>
    <ss:Style ss:Parent="odd" ss:ID="oddfloat">
        <ss:NumberFormat ss:Format="0.00" />
    </ss:Style>
</ss:Styles>
<ss:Worksheet ss:Name="用户使用机型及人数">
<ss:Names>
    <ss:NamedRange ss:Name="Print_Titles" ss:RefersTo="='用户使用机型及人数'!R1:R2" />
</ss:Names>
<ss:Table x:FullRows="1" x:FullColumns="1" ss:ExpandedColumnCount="6" ss:ExpandedRowCount="7">
    <ss:Column ss:AutoFitWidth="1" ss:Width="130" />
    <ss:Column ss:AutoFitWidth="1" ss:Width="130" />
    <ss:Column ss:AutoFitWidth="1" ss:Width="130" />
    <ss:Column ss:AutoFitWidth="1" ss:Width="130" />
    <ss:Row ss:AutoFitHeight="1">
        <ss:Cell ss:StyleID="headercell">
            <ss:Data ss:Type="String">机型号</ss:Data>
            <ss:NamedCell ss:Name="Print_Titles" />
        </ss:Cell>
        <ss:Cell ss:StyleID="headercell">
            <ss:Data ss:Type="String">新增用户</ss:Data>
            <ss:NamedCell ss:Name="Print_Titles" />
        </ss:Cell>
        <ss:Cell ss:StyleID="headercell">
            <ss:Data ss:Type="String">启动次数</ss:Data>
            <ss:NamedCell ss:Name="Print_Titles" />
        </ss:Cell>
        <ss:Cell ss:StyleID="headercell">
            <ss:Data ss:Type="String">日期</ss:Data>
            <ss:NamedCell ss:Name="Print_Titles" />
        </ss:Cell>
    </ss:Row>
    <ss:Row>
        <ss:Cell ss:StyleID="even">
            <ss:Data ss:Type="String">PL-14</ss:Data>
        </ss:Cell>
        <ss:Cell ss:StyleID="even">
            <ss:Data ss:Type="String">21</ss:Data>
        </ss:Cell>
        <ss:Cell ss:StyleID="even">
            <ss:Data ss:Type="String">43</ss:Data>
        </ss:Cell>
            <ss:Cell ss:StyleID="even">
            <ss:Data ss:Type="String">2016-03-01</ss:Data>
        </ss:Cell>
    </ss:Row>
    <ss:Row>
        <ss:Cell ss:StyleID="odd">
            <ss:Data ss:Type="String">F-10</ss:Data>
        </ss:Cell>
        <ss:Cell ss:StyleID="odd">
            <ss:Data ss:Type="String">56</ss:Data>
        </ss:Cell>
        <ss:Cell ss:StyleID="odd">
            <ss:Data ss:Type="String">98</ss:Data>
        </ss:Cell>
        <ss:Cell ss:StyleID="odd">
            <ss:Data ss:Type="String">2016-02-29</ss:Data>
        </ss:Cell>
    </ss:Row>
    </ss:Table>
    <x:WorksheetOptions>
    <x:PageSetup>
        <x:Layout x:CenterHorizontal="1" x:Orientation="Landscape" />
        <x:Footer x:Data="Page &P of &N" x:Margin="0.5" />
        <x:PageMargins x:Top="0.5" x:Right="0.5" x:Left="0.5" x:Bottom="0.8" />
    </x:PageSetup>
    <x:FitToPage />
        <x:Print>
            <x:PrintErrors>Blank</x:PrintErrors>
            <x:FitWidth>1</x:FitWidth>
            <x:FitHeight>32767</x:FitHeight>
            <x:ValidPrinterInfo />
            <x:VerticalResolution>600</x:VerticalResolution>
        </x:Print>
    <x:Selected />
    <x:DoNotDisplayGridlines />
    <x:ProtectObjects>False</x:ProtectObjects>
    <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
</ss:Worksheet>
</ss:Workbook>

如何使用上面的数据创建一个excel文件
这个样子的:
图片说明
哪位大神没事帮我看看~ 拜谢~

1个回答

Royal_lr
Royal_lr   Ds   Rxr 2016.02.26 18:50

直接用jxl或者poi创建一个excel'不久完了,,搞这么麻烦

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!