「得意先テーブル」の xml出力の例


<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<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://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <LastAuthor>Makoto WATANABE</LastAuthor>
  <Created>2005-02-20T12:32:22Z</Created>
  <Version>11.5606</Version>
 </DocumentProperties>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>10830</WindowHeight>
  <WindowWidth>17055</WindowWidth>
  <WindowTopX>360</WindowTopX>
  <WindowTopY>75</WindowTopY>
  <AcceptLabelsInFormulas/>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="ＭＳ ゴシック" x:CharSet="128" x:Family="Modern"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s23">
   <NumberFormat/>
  </Style>
 </Styles>
 <Names>
  <NamedRange ss:Name="得意先" ss:RefersTo="=得意先!R1C1:R52C7"/>
 </Names>
 <Worksheet ss:Name="得意先">
  <Table ss:ExpandedColumnCount="7" ss:ExpandedRowCount="52" x:FullColumns="1" x:FullRows="1" ss:DefaultRowHeight="12">
   <Column ss:AutoFitWidth="0" ss:Width="105.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="111"/>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">得意先</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">出荷先名</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">出荷先郵便番号</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">出荷先都道府県</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">出荷先住所1</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">運送料</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">ID</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">アリス亭</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">アリス亭</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">270-0234</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">千葉県</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">野田市日之出町 27-XX</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">1000</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">1</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">イルカラン</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">イルカラン</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">144-0047</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">東京都</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">大田区萩中 2-4-X</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">1000</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">2</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">コーヒーハ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">コーヒーハ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">299-1100</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">千葉県</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">君津市袖ケ浦町野里 1539-X</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">1000</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">3</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">コンビニエ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">コンビニエ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">232-0061</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">神奈川県</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">横浜市南区大岡 1-44-X</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">1000</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">4</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">ジャンボス</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">ジャンボス</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">286-0036</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">千葉県</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">成田市加良部 5-3-X</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">1000</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">5</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">パーラーえ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">パーラーえ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">178-0063</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">東京都</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">練馬区東大泉 1-26-31-XXX</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">1000</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">6</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">びしゃもん</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">びしゃもん</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">286-0003</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">千葉県</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">成田市台方 XXX</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">1000</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">7</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">ヒロコーポ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">ヒロコーポ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">241-0831</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">神奈川県</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">横浜市旭区左近山 3-18-XXX</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">0</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">8</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>
   <Row>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">ヒロコーポ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">ヒロコーポ</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">241-0831</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">神奈川県</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="String" x:Ticked="1">横浜市旭区左近山 3-18-XXX</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">1000</Data><NamedCell ss:Name="得意先"/></Cell>
    <Cell ss:StyleID="s23"><Data ss:Type="Number">9</Data><NamedCell ss:Name="得意先"/></Cell>
   </Row>

  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <PageSetup>
    <Header x:Data="&amp;A"/>
    <Footer x:Data="Page &amp;P"/>
    <PageMargins x:Bottom="0.98399999999999999" x:Left="0.78700000000000003"
     x:Right="0.78700000000000003" x:Top="0.98399999999999999"/>
   </PageSetup>
   <Selected/>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
  </WorksheetOptions>
 </Worksheet>
</Workbook>
このページのトップ↑　←テーブル正規化ウィザードに戻る　 Accessでお仕事目次