凡夫俗子_ 2016-02-26 08:20 采纳率: 0%
浏览 1357
已结题

【小白求助】excel问题

 <?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 2016-02-26 10:50
    关注

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

    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿