XML en L2, TP 1

Un fichier-archive, une base de données MySql, un document XML, un objet (au sens de la programmation objets) ou même un DVD du commerce sont des conteneurs dans la mesure où ils permettent de regrouper des contenus (données) hétérogènes : une base de données contient des tables qui elles-mêmes contiennent des champs, l'élément racine du document XML peut contenir d'autres éléments qui peuvent contenir eux-mêmes d'autres éléments, un objet en PO peut contenir plusieurs variables-mémoires, voire plusieurs tableaux ou d'autres objets, un DVD du commerce contient des vidéos, des sous-titres, voire des menus, des images... Ce qu'apportent en plus XML et l'objet, c'est la possibilité d'agir sur leurs contenus...

On pourrait exporter une base de données en XML avec la structure suivante (MySql dispose d'une option de sortie HTML et d'une option de sortie XML qui ressemble un peu à celle-ci) :


     <baseDeDonnées>
     
       <table1>
         <ligne1>
            <colonne1>
             [... données de la table 1]
            </colonne1>
            <colonne2>
            ...
            </colonne2>
            ...
         <ligne1>
       </table1>
     
       <table2>
         [... données de la table 2]
       </table2>
     
       ...
     
     </baseDeDonnées>

Les fichiers .ODS et .DOCX sont des documents compressés, c'est-à-dire des archives et ne peuvent donc pas être lus directement. Seul le format .RTF est lisible, si l'on peut dire. En voici le contenu :


     {\rtf1\ansi\deff3\adeflang1025
     {\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fprq2\fcharset2 Symbol;}
      {\f2\fswiss\fprq2\fcharset0 Arial;}{\f3\froman\fprq2\fcharset128 Times New Roman;}
       {\f4\fswiss\fprq2\fcharset128 Arial;}{\f5\fnil\fprq2\fcharset128 WenQuanYi Micro Hei;}
        {\f6\fnil\fprq2\fcharset128 Lohit Hindi;}{\f7\fnil\fprq0\fcharset128 Lohit Hindi;}}
     {\colortbl;\red0\green0\blue0;\red0\green0\blue255;\red128\green128\blue128;}
     {\stylesheet{\s0\snext0\nowidctlpar{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}
      \cf0\kerning1\hich\af5\langfe2052\dbch\af6\afs24\alang1081\loch\f3\fs24\lang1036 Standard;}
     {\*\cs15\snext15\b\ab Accentuation forte;}
     {\s16\sbasedon0\snext17\sb240\sa120\keepn\hich\af5\dbch\af6\afs28\loch\f4\fs28 Titre;}
     {\s17\sbasedon0\snext17\sb0\sa120 Corps de texte;}
     {\s18\sbasedon17\snext18\sb0\sa120\dbch\af7 Liste;}
     {\s19\sbasedon0\snext19\sb120\sa120\noline\i\dbch\af7\afs24\ai\fs24 L\u233\'3fgende;}
     {\s20\sbasedon0\snext20\noline\dbch\af7 Index;}
     }{\info{\author Hunault }{\creatim\yr2012\mo7\dy23\hr22\min18}{\revtim\yr0\mo0\dy0\hr0\min0}
     {\printim\yr0\mo0\dy0\hr0\min0}{\comment LibreOffice}{\vern3500}}\deftab709
     
     {\*\pgdsctbl
     {\pgdsc0\pgdscuse195\pgwsxn11906\pghsxn16838\marglsxn1134\margrsxn1134
      \margtsxn1134\margbsxn1134\pgdscnxt0 Standard;}}
     \formshade\paperh16838\paperw11906\margl1134\margr1134\margt1134\margb1134
     \sectd\sbknone\sectunlocked1\pgndec\pgwsxn11906\pghsxn16838\marglsxn1134
     \margrsxn1134\margtsxn1134\margbsxn1134\ftnbj\ftnstart1\ftnrstcont\ftnnar\aenddoc
     \aftnrstcont\aftnstart1\aftnnrlc
     \pgndec\pard\plain \s0\nowidctlpar{\*\hyphen2\hyphlead2\hyphtrail2\hyphmax0}
     \cf0\kerning1\hich\af5\langfe2052\dbch\af6\afs24\alang1081\loch\f3\fs24\lang1036
     {\cs15\b\ab\b0\ab0\rtlch \ltrch\loch
     Bon }{\cs15\b\ab\b\ab\rtlch \ltrch\loch
     courage}{\cs15\b\ab\b0\ab0\rtlch \ltrch\loch
      \uc2 \u224\'c3\'a0 \uc1 }{\cs15\b\ab\cf2\b0\ab0\rtlch \ltrch\loch
     tous}{\cs15\b\ab\b0\ab0\rtlch \ltrch\loch
      et \uc2 \u224\'c3\'a0 \uc1 }{\cs15\b\ab\cf2\b\ab\rtlch \ltrch\loch
     toutes}
     \par }

Un afffichage plus lisible pour un fichier similaire se trouve à l'adresse courage.rtfste qui correspond à l'exercice 9 de nos exercices PHP série 1 (énoncé, solution). On pourra aussi consulter l'exercice 1 de notre cours FarCompr, partie stockage (énoncé,solution).

Pour retrouver les fichiers des archives, il suffit d'utiliser un décompresseur comme unzip par exemple :


     $gh> unzip -v boncourage.odt
     
     Archive:  boncourage.odt
      Length   Method    Size  Cmpr    Date    Time   CRC-32   Name
     --------  ------  ------- ---- ---------- ----- --------  ----
           39  Stored       39   0% 2012-07-23 20:24 0c32c65e  mimetype
          869  Stored      869   0% 2012-07-23 20:24 8a9d38c1  meta.xml
         9005  Defl:N     1393  85% 2012-07-23 20:24 7685b30d  settings.xml
         4469  Defl:N      966  78% 2012-07-23 20:24 7ee053d5  content.xml
         1240  Stored     1240   0% 2012-07-23 20:24 1549604c  Thumbnails/thumbnail.png
          899  Defl:N      261  71% 2012-07-23 20:24 d268f7b4  manifest.rdf
            0  Stored        0   0% 2012-07-23 20:24 00000000  Configurations2/images/Bitmaps/
            0  Stored        0   0% 2012-07-23 20:24 00000000  Configurations2/popupmenu/
            0  Stored        0   0% 2012-07-23 20:24 00000000  Configurations2/toolpanel/
            0  Stored        0   0% 2012-07-23 20:24 00000000  Configurations2/statusbar/
            0  Stored        0   0% 2012-07-23 20:24 00000000  Configurations2/progressbar/
            0  Stored        0   0% 2012-07-23 20:24 00000000  Configurations2/toolbar/
            0  Stored        0   0% 2012-07-23 20:24 00000000  Configurations2/floater/
            0  Stored        0   0% 2012-07-23 20:24 00000000  Configurations2/menubar/
            0  Defl:N        2   0% 2012-07-23 20:24 00000000  Configurations2/accelerator/current.xml
        11214  Defl:N     2071  82% 2012-07-23 20:24 7b480a79  styles.xml
         1086  Defl:N      289  73% 2012-07-23 20:24 1205fba3  META-INF/manifest.xml
     --------          -------  ---                            -------
        28821             7130  75%                            17 files
     
     $gh> unzip -v boncourage.docx
     
     Archive:  boncourage.docx
      Length   Method    Size  Cmpr    Date    Time   CRC-32   Name
     --------  ------  ------- ---- ---------- ----- --------  ----
          573  Defl:N      217  62% 2012-07-23 20:23 2301d0e8  _rels/.rels
          595  Defl:N      224  62% 2012-07-23 20:23 21e3b303  word/fontTable.xml
          400  Defl:N      184  54% 2012-07-23 20:23 6294fd88  word/_rels/document.xml.rels
         1521  Defl:N      484  68% 2012-07-23 20:23 218c2506  word/document.xml
         2085  Defl:N      604  71% 2012-07-23 20:23 458984fb  word/styles.xml
          267  Defl:N      163  39% 2012-07-23 20:23 8f99c3e9  docProps/app.xml
          509  Defl:N      284  44% 2012-07-23 20:23 3004c3c0  docProps/core.xml
          987  Defl:N      286  71% 2012-07-23 20:23 606aa6aa  [Content_Types].xml
     --------          -------  ---                            -------
         6937             2446  65%                            8 files

Les «vrais» fichiers pour Open Office et Microsoft Office sont nommés respectivement content.xml et document.xml :


     $gh> cat content.xml
     
     <?xml version="1.0" encoding="UTF-8"?>
     <office:document-content
     xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
     xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0"
     xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0"
     xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0"
     xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0"
     xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0"
     xmlns:xlink="http://www.w3.org/1999/xlink"
     xmlns:dc="http://purl.org/dc/elements/1.1/"
     xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0"
     xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0"
     xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0"
     xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0"
     xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0"
     xmlns:math="http://www.w3.org/1998/Math/MathML"
     xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0"
     xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0"
     xmlns:ooo="http://openoffice.org/2004/office"
     xmlns:ooow="http://openoffice.org/2004/writer"
     xmlns:oooc="http://openoffice.org/2004/calc"
     xmlns:dom="http://www.w3.org/2001/xml-events"
     xmlns:xforms="http://www.w3.org/2002/xforms"
     xmlns:xsd="http://www.w3.org/2001/XMLSchema"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xmlns:rpt="http://openoffice.org/2005/report"
     xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2"
     xmlns:xhtml="http://www.w3.org/1999/xhtml"
     xmlns:grddl="http://www.w3.org/2003/g/data-view#"
     xmlns:tableooo="http://openoffice.org/2009/table"
     xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0"
     xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0"
     xmlns:css3t="http://www.w3.org/TR/css3-text/"
     office:version="1.2"><office:scripts/>
     
     <office:font-face-decls><style:font-face style:name="Lohit Hindi1" svg:font-family="&apos;Lohit Hindi&apos;"/>
     <style:font-face style:name="Times New Roman" svg:font-family="&apos;Times New Roman&apos;" style:font-family-generic="roman"
     style:font-pitch="variable"/><style:font-face style:name="Arial" svg:font-family="Arial" style:font-family-generic="swiss"
     style:font-pitch="variable"/><style:font-face style:name="Lohit Hindi" svg:font-family="&apos;Lohit Hindi&apos;"
     style:font-family-generic="system" style:font-pitch="variable"/><style:font-face style:name="WenQuanYi Micro Hei"
     svg:font-family="&apos;WenQuanYi Micro Hei&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
     </office:font-face-decls><office:automatic-styles><style:style style:name="T1" style:family="text">
     <style:text-properties fo:font-weight="normal" style:font-weight-asian="normal" style:font-weight-complex="normal"/>
     </style:style><style:style style:name="T2" style:family="text"><style:text-properties fo:font-weight="bold"
     style:font-weight-asian="bold" style:font-weight-complex="bold"/></style:style><style:style style:name="T3"
     style:family="text"><style:text-properties fo:color="#0000ff" fo:font-weight="normal" style:font-weight-asian="normal"
     style:font-weight-complex="normal"/></style:style><style:style style:name="T4" style:family="text">
     <style:text-properties fo:color="#0000ff" fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
     </style:style></office:automatic-styles>
     
     <office:body>
     <office:text><text:sequence-decls><text:sequence-decl
     text:display-outline-level="0" text:name="Illustration"/><text:sequence-decl text:display-outline-level="0"
     text:name="Table"/><text:sequence-decl text:display-outline-level="0" text:name="Text"/><text:sequence-decl
     text:display-outline-level="0" text:name="Drawing"/></text:sequence-decls><text:p text:style-name="Standard">
     <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T1">Bon </text:span></text:span>
     <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T2">courage</text:span></text:span>
     <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T1"> à </text:span></text:span>
     <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T3">tous</text:span></text:span>
     <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T1"> et à </text:span></text:span>
     <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T4">toutes</text:span></text:span>
     </text:p></office:text>
     </office:body>
     
     </office:document-content>
     
     $gh> cat document.xml
     
     <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
     
     <w:document
     xmlns:o="urn:schemas-microsoft-com:office:office"
     xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
     xmlns:v="urn:schemas-microsoft-com:vml"
     xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"
     xmlns:w10="urn:schemas-microsoft-com:office:word"
     xmlns:wp="http://schemas.openxmlformats.org/drawingml/2006/wordprocessingDrawing">
     
     <w:body>
     <w:p><w:pPr><w:pStyle w:val="style0"/></w:pPr><w:r><w:rPr><w:rStyle w:val="style15"/><w:b w:val="false"/>
     <w:bCs w:val="false"/></w:rPr><w:t xml:space="preserve">Bon </w:t></w:r><w:r><w:rPr><w:rStyle w:val="style15"/>
     <w:b/><w:bCs/></w:rPr><w:t>courage</w:t></w:r><w:r><w:rPr><w:rStyle w:val="style15"/><w:b w:val="false"/>
     <w:bCs w:val="false"/></w:rPr><w:t xml:space="preserve"> à </w:t></w:r><w:r><w:rPr><w:rStyle w:val="style15"/>
     <w:b w:val="false"/><w:bCs w:val="false"/><w:color w:val="0000FF"/></w:rPr><w:t>tous</w:t></w:r><w:r><w:rPr>
     <w:rStyle w:val="style15"/><w:b w:val="false"/><w:bCs w:val="false"/></w:rPr><w:t xml:space="preserve"> et à
     </w:t></w:r><w:r><w:rPr><w:rStyle w:val="style15"/><w:b/><w:bCs/><w:color w:val="0000FF"/></w:rPr><w:t>toutes</w:t></w:r></w:p>
     <w:sectPr><w:type w:val="nextPage"/><w:pgSz w:h="16838" w:w="11906"/><w:pgMar w:bottom="1134" w:footer="0"
     w:gutter="0" w:header="0" w:left="1134" w:right="1134" w:top="1134"/><w:pgNumType w:fmt="decimal"/>
     <w:formProt w:val="false"/><w:textDirection w:val="lrTb"/></w:sectPr>
     </w:body>
     
     </w:document>

Si la documentation du Wiki français détaille ce que sont les fichiers Open Document, elle ne dit rien sur ce qu'est le format .FODT alors que la documentation du Wiki anglais explique qu'il s'agit d'un format «à plat» (non compressé) monobloc (tout en un seul fichier). On pourra le vérifier en consultant boncourage.fodt (judicieusement recopié en boncourage_fodt.xml) dont le contenu est :


     $gh> cat boncourage.fodt
     
     
     <?xml version="1.0" encoding="UTF-8"?>
     
     <office:document
     xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
     xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0"
     xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0"
     xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0"
     xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0"
     xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0"
     xmlns:xlink="http://www.w3.org/1999/xlink"
     xmlns:dc="http://purl.org/dc/elements/1.1/"
     xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0"
     xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0"
     xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0"
     xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0"
     xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0"
     xmlns:math="http://www.w3.org/1998/Math/MathML"
     xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0"
     xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0"
     xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0"
     xmlns:ooo="http://openoffice.org/2004/office"
     xmlns:ooow="http://openoffice.org/2004/writer"
     xmlns:oooc="http://openoffice.org/2004/calc"
     xmlns:dom="http://www.w3.org/2001/xml-events"
     xmlns:xforms="http://www.w3.org/2002/xforms"
     xmlns:xsd="http://www.w3.org/2001/XMLSchema"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xmlns:rpt="http://openoffice.org/2005/report"
     xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2"
     xmlns:xhtml="http://www.w3.org/1999/xhtml"
     xmlns:grddl="http://www.w3.org/2003/g/data-view#"
     xmlns:tableooo="http://openoffice.org/2009/table"
     xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0"
     xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0"
     xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2" office:mimetype="application/vnd.oasis.opendocument.text">
     
     <office:meta>
     <meta:initial-creator>Hunault </meta:initial-creator>
     <meta:creation-date>2012-07-23T22:18:01</meta:creation-date>
     <meta:generator>LibreOffice/3.5$Linux_X86_64 LibreOffice_project/350m1$Build-2</meta:generator>
     <meta:document-statistic meta:table-count="0" meta:image-count="0"
     meta:object-count="0" meta:page-count="1" meta:paragraph-count="1"
     meta:word-count="7" meta:character-count="30"
     meta:non-whitespace-character-count="24"/>
     </office:meta>
     
     <office:settings>
       <config:config-item-set config:name="ooo:view-settings">
        <config:config-item config:name="ViewAreaTop" config:type="long">0</config:config-item>
        <config:config-item config:name="ViewAreaLeft" config:type="long">0</config:config-item>
        <config:config-item config:name="ViewAreaWidth" config:type="long">19738</config:config-item>
        <config:config-item config:name="ViewAreaHeight" config:type="long">13741</config:config-item>
        <config:config-item config:name="ShowRedlineChanges" config:type="boolean">true</config:config-item>
        <config:config-item config:name="InBrowseMode" config:type="boolean">false</config:config-item>
        <config:config-item-map-indexed config:name="Views">
         <config:config-item-map-entry>
          <config:config-item config:name="ViewId" config:type="string">view2</config:config-item>
          <config:config-item config:name="ViewLeft" config:type="long">8246</config:config-item>
          <config:config-item config:name="ViewTop" config:type="long">3002</config:config-item>
          <config:config-item config:name="VisibleLeft" config:type="long">0</config:config-item>
          <config:config-item config:name="VisibleTop" config:type="long">0</config:config-item>
          <config:config-item config:name="VisibleRight" config:type="long">19736</config:config-item>
          <config:config-item config:name="VisibleBottom" config:type="long">13739</config:config-item>
          <config:config-item config:name="ZoomType" config:type="short">0</config:config-item>
          <config:config-item config:name="ViewLayoutColumns" config:type="short">0</config:config-item>
          <config:config-item config:name="ViewLayoutBookMode" config:type="boolean">false</config:config-item>
          <config:config-item config:name="ZoomFactor" config:type="short">135</config:config-item>
          <config:config-item config:name="IsSelectedFrame" config:type="boolean">false</config:config-item>
         </config:config-item-map-entry>
        </config:config-item-map-indexed>
       </config:config-item-set>
       <config:config-item-set config:name="ooo:configuration-settings">
        <config:config-item config:name="PrintTables" config:type="boolean">true</config:config-item>
        <config:config-item config:name="AddParaTableSpacingAtStart" config:type="boolean">true</config:config-item>
        <config:config-item config:name="ChartAutoUpdate" config:type="boolean">true</config:config-item>
        <config:config-item config:name="IsLabelDocument" config:type="boolean">false</config:config-item>
        <config:config-item config:name="MathBaselineAlignment" config:type="boolean">true</config:config-item>
        <config:config-item config:name="OutlineLevelYieldsNumbering" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintLeftPages" config:type="boolean">true</config:config-item>
        <config:config-item config:name="AlignTabStopPosition" config:type="boolean">true</config:config-item>
        <config:config-item config:name="DoNotJustifyLinesWithManualBreak" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintTextPlaceholder" config:type="boolean">false</config:config-item>
        <config:config-item config:name="UseOldNumbering" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintProspectRTL" config:type="boolean">false</config:config-item>
        <config:config-item config:name="ProtectForm" config:type="boolean">false</config:config-item>
        <config:config-item config:name="CurrentDatabaseCommand" config:type="string"/>
        <config:config-item config:name="PrintBlackFonts" config:type="boolean">false</config:config-item>
        <config:config-item config:name="SmallCapsPercentage66" config:type="boolean">false</config:config-item>
        <config:config-item config:name="CharacterCompressionType" config:type="short">0</config:config-item>
        <config:config-item config:name="PrintControls" config:type="boolean">true</config:config-item>
        <config:config-item config:name="PrintHiddenText" config:type="boolean">false</config:config-item>
        <config:config-item config:name="IsKernAsianPunctuation" config:type="boolean">false</config:config-item>
        <config:config-item config:name="UseFormerTextWrapping" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintProspect" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintEmptyPages" config:type="boolean">true</config:config-item>
        <config:config-item config:name="UnbreakableNumberings" config:type="boolean">false</config:config-item>
        <config:config-item config:name="UseFormerObjectPositioning" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintReversed" config:type="boolean">false</config:config-item>
        <config:config-item config:name="TabsRelativeToIndent" config:type="boolean">true</config:config-item>
        <config:config-item config:name="TableRowKeep" config:type="boolean">false</config:config-item>
        <config:config-item config:name="ConsiderTextWrapOnObjPos" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintRightPages" config:type="boolean">true</config:config-item>
        <config:config-item config:name="PrintPaperFromSetup" config:type="boolean">false</config:config-item>
        <config:config-item config:name="AddFrameOffsets" config:type="boolean">false</config:config-item>
        <config:config-item config:name="UpdateFromTemplate" config:type="boolean">true</config:config-item>
        <config:config-item config:name="AddParaSpacingToTableCells" config:type="boolean">true</config:config-item>
        <config:config-item config:name="PrintSingleJobs" config:type="boolean">false</config:config-item>
        <config:config-item config:name="AddExternalLeading" config:type="boolean">true</config:config-item>
        <config:config-item config:name="PrinterIndependentLayout" config:type="string">high-resolution</config:config-item>
        <config:config-item config:name="LinkUpdateMode" config:type="short">1</config:config-item>
        <config:config-item config:name="PrintAnnotationMode" config:type="short">0</config:config-item>
        <config:config-item config:name="UseOldPrinterMetrics" config:type="boolean">false</config:config-item>
        <config:config-item config:name="RedlineProtectionKey" config:type="base64Binary"/>
        <config:config-item config:name="PrinterName" config:type="string"/>
        <config:config-item config:name="CollapseEmptyCellPara" config:type="boolean">true</config:config-item>
        <config:config-item config:name="PrinterSetup" config:type="base64Binary"/>
        <config:config-item config:name="IgnoreFirstLineIndentInNumbering" config:type="boolean">false</config:config-item>
        <config:config-item config:name="InvertBorderSpacing" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintPageBackground" config:type="boolean">true</config:config-item>
        <config:config-item config:name="DoNotCaptureDrawObjsOnPage" config:type="boolean">false</config:config-item>
        <config:config-item config:name="TabOverflow" config:type="boolean">true</config:config-item>
        <config:config-item config:name="ApplyUserData" config:type="boolean">true</config:config-item>
        <config:config-item config:name="TabAtLeftIndentForParagraphsInList" config:type="boolean">false</config:config-item>
        <config:config-item config:name="UnxForceZeroExtLeading" config:type="boolean">false</config:config-item>
        <config:config-item config:name="SaveVersionOnClose" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintFaxName" config:type="string"/>
        <config:config-item config:name="PrintDrawings" config:type="boolean">true</config:config-item>
        <config:config-item config:name="AddParaTableSpacing" config:type="boolean">true</config:config-item>
        <config:config-item config:name="LoadReadonly" config:type="boolean">false</config:config-item>
        <config:config-item config:name="PrintGraphics" config:type="boolean">true</config:config-item>
        <config:config-item config:name="FieldAutoUpdate" config:type="boolean">true</config:config-item>
        <config:config-item config:name="AllowPrintJobCancel" config:type="boolean">true</config:config-item>
        <config:config-item config:name="SaveGlobalDocumentLinks" config:type="boolean">false</config:config-item>
        <config:config-item config:name="CurrentDatabaseDataSource" config:type="string"/>
        <config:config-item config:name="UseFormerLineSpacing" config:type="boolean">false</config:config-item>
        <config:config-item config:name="IgnoreTabsAndBlanksForLineCalculation" config:type="boolean">false</config:config-item>
        <config:config-item config:name="CurrentDatabaseCommandType" config:type="int">0</config:config-item>
        <config:config-item config:name="DoNotResetParaAttrsForNumFont" config:type="boolean">false</config:config-item>
        <config:config-item config:name="ClipAsCharacterAnchoredWriterFlyFrames" config:type="boolean">false</config:config-item>
       </config:config-item-set>
     </office:settings>
     
     <office:scripts>
       <office:script script:language="ooo:Basic">
        <ooo:libraries xmlns:ooo="http://openoffice.org/2004/office" xmlns:xlink="http://www.w3.org/1999/xlink">
         <ooo:library-embedded ooo:name="Standard"/>
        </ooo:libraries>
       </office:script>
      </office:scripts>
     
      <office:font-face-decls>
       <style:font-face style:name="Lohit Hindi1" svg:font-family="&apos;Lohit Hindi&apos;"/>
       <style:font-face style:name="Times New Roman"
         svg:font-family="&apos;Times New Roman&apos;" style:font-family-generic="roman" style:font-pitch="variable"/>
       <style:font-face style:name="Arial"
         svg:font-family="Arial" style:font-family-generic="swiss" style:font-pitch="variable"/>
       <style:font-face style:name="Lohit Hindi"
         svg:font-family="&apos;Lohit Hindi&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
       <style:font-face style:name="WenQuanYi Micro Hei"
         svg:font-family="&apos;WenQuanYi Micro Hei&apos;" style:font-family-generic="system" style:font-pitch="variable"/>
      </office:font-face-decls>
     
      <office:styles>
       <style:default-style style:family="graphic">
        <style:graphic-properties svg:stroke-color="#808080" draw:fill-color="#cfe7f5"
        fo:wrap-option="no-wrap" draw:shadow-offset-x="0.3cm" draw:shadow-offset-y="0.3cm"
        draw:start-line-spacing-horizontal="0.283cm" draw:start-line-spacing-vertical="0.283cm"
        draw:end-line-spacing-horizontal="0.283cm" draw:end-line-spacing-vertical="0.283cm" style:flow-with-text="false"/>
        <style:paragraph-properties style:text-autospace="ideograph-alpha" style:line-break="strict"
        style:writing-mode="lr-tb" style:font-independent-line-spacing="false">
         <style:tab-stops/>
        </style:paragraph-properties>
        <style:text-properties style:use-window-font-color="true" fo:font-size="12pt" fo:language="fr"
        fo:country="FR" style:letter-kerning="true" style:font-size-asian="10.5pt" style:language-asian="zh"
        style:country-asian="CN" style:font-size-complex="12pt" style:language-complex="hi" style:country-complex="IN"/>
       </style:default-style>
       <style:default-style style:family="paragraph">
        <style:paragraph-properties fo:hyphenation-ladder-count="no-limit" style:text-autospace="ideograph-alpha"
        style:punctuation-wrap="hanging" style:line-break="strict" style:tab-stop-distance="1.251cm" style:writing-mode="page"/>
        <style:text-properties style:use-window-font-color="true" style:font-name="Times New Roman"
        fo:font-size="12pt" fo:language="fr" fo:country="FR" style:letter-kerning="true"
        style:font-name-asian="WenQuanYi Micro Hei" style:font-size-asian="10.5pt"
        style:language-asian="zh" style:country-asian="CN" style:font-name-complex="Lohit Hindi"
        style:font-size-complex="12pt" style:language-complex="hi" style:country-complex="IN"
        fo:hyphenate="false" fo:hyphenation-remain-char-count="2" fo:hyphenation-push-char-count="2"/>
       </style:default-style>
       <style:default-style style:family="table">
        <style:table-properties table:border-model="collapsing"/>
       </style:default-style>
       <style:default-style style:family="table-row">
        <style:table-row-properties fo:keep-together="auto"/>
       </style:default-style>
       <style:style style:name="Standard" style:family="paragraph" style:class="text"/>
       <style:style style:name="Heading" style:family="paragraph" style:parent-style-name="Standard"
       style:next-style-name="Text_20_body" style:class="text">
        <style:paragraph-properties fo:margin-top="0.423cm" fo:margin-bottom="0.212cm"
        fo:keep-with-next="always"/>
        <style:text-properties style:font-name="Arial" fo:font-size="14pt" style:font-name-asian="WenQuanYi Micro Hei"
        style:font-size-asian="14pt" style:font-name-complex="Lohit Hindi" style:font-size-complex="14pt"/>
       </style:style>
       <style:style style:name="Text_20_body" style:display-name="Text body" style:family="paragraph"
       style:parent-style-name="Standard" style:class="text">
        <style:paragraph-properties fo:margin-top="0cm" fo:margin-bottom="0.212cm"/>
       </style:style>
       <style:style style:name="List" style:family="paragraph" style:parent-style-name="Text_20_body"
       style:class="list">
        <style:text-properties style:font-size-asian="12pt" style:font-name-complex="Lohit Hindi1"/>
       </style:style>
       <style:style style:name="Caption" style:family="paragraph" style:parent-style-name="Standard" style:class="extra">
        <style:paragraph-properties fo:margin-top="0.212cm" fo:margin-bottom="0.212cm"
        text:number-lines="false" text:line-number="0"/>
        <style:text-properties fo:font-size="12pt" fo:font-style="italic" style:font-size-asian="12pt"
        style:font-style-asian="italic" style:font-name-complex="Lohit Hindi1"
        style:font-size-complex="12pt" style:font-style-complex="italic"/>
       </style:style>
       <style:style style:name="Index" style:family="paragraph" style:parent-style-name="Standard"
       style:class="index">
        <style:paragraph-properties text:number-lines="false" text:line-number="0"/>
        <style:text-properties style:font-size-asian="12pt" style:font-name-complex="Lohit Hindi1"/>
       </style:style>
       <style:style style:name="Strong_20_Emphasis" style:display-name="Strong Emphasis" style:family="text">
        <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
       </style:style>
       <text:outline-style style:name="Outline">
        <text:outline-level-style text:level="1" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="0.762cm" fo:text-indent="-0.762cm" fo:margin-left="0.762cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
        <text:outline-level-style text:level="2" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="1.016cm" fo:text-indent="-1.016cm" fo:margin-left="1.016cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
        <text:outline-level-style text:level="3" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="1.27cm" fo:text-indent="-1.27cm" fo:margin-left="1.27cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
        <text:outline-level-style text:level="4" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="1.524cm" fo:text-indent="-1.524cm" fo:margin-left="1.524cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
        <text:outline-level-style text:level="5" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="1.778cm" fo:text-indent="-1.778cm" fo:margin-left="1.778cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
        <text:outline-level-style text:level="6" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="2.032cm" fo:text-indent="-2.032cm" fo:margin-left="2.032cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
        <text:outline-level-style text:level="7" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="2.286cm" fo:text-indent="-2.286cm" fo:margin-left="2.286cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
        <text:outline-level-style text:level="8" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="2.54cm" fo:text-indent="-2.54cm" fo:margin-left="2.54cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
        <text:outline-level-style text:level="9" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="2.794cm" fo:text-indent="-2.794cm" fo:margin-left="2.794cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
        <text:outline-level-style text:level="10" style:num-format="">
         <style:list-level-properties text:list-level-position-and-space-mode="label-alignment">
          <style:list-level-label-alignment text:label-followed-by="listtab"
          text:list-tab-stop-position="3.048cm" fo:text-indent="-3.048cm" fo:margin-left="3.048cm"/>
         </style:list-level-properties>
        </text:outline-level-style>
       </text:outline-style>
       <text:notes-configuration text:note-class="footnote" style:num-format="1"
       text:start-value="0" text:footnotes-position="page" text:start-numbering-at="document"/>
       <text:notes-configuration text:note-class="endnote" style:num-format="i"
       text:start-value="0"/>
       <text:linenumbering-configuration text:number-lines="false"
       text:offset="0.499cm" style:num-format="1" text:number-position="left" text:increment="5"/>
      </office:styles>
      <office:automatic-styles>
       <style:style style:name="T1" style:family="text">
        <style:text-properties fo:font-weight="normal"
        style:font-weight-asian="normal" style:font-weight-complex="normal"/>
       </style:style>
       <style:style style:name="T2" style:family="text">
        <style:text-properties fo:font-weight="bold"
        style:font-weight-asian="bold" style:font-weight-complex="bold"/>
       </style:style>
       <style:style style:name="T3" style:family="text">
        <style:text-properties fo:color="#0000ff" fo:font-weight="normal"
        style:font-weight-asian="normal" style:font-weight-complex="normal"/>
       </style:style>
       <style:style style:name="T4" style:family="text">
        <style:text-properties fo:color="#0000ff" fo:font-weight="bold"
        style:font-weight-asian="bold" style:font-weight-complex="bold"/>
       </style:style>
       <style:page-layout style:name="pm1">
        <style:page-layout-properties fo:page-width="21.001cm" fo:page-height="29.7cm"
        style:num-format="1" style:print-orientation="portrait" fo:margin="2cm" fo:margin-top="2cm"
        fo:margin-bottom="2cm" fo:margin-left="2cm" fo:margin-right="2cm" style:writing-mode="lr-tb"
        style:footnote-max-height="0cm">
         <style:footnote-sep style:width="0.018cm" style:distance-before-sep="0.101cm"
         style:distance-after-sep="0.101cm" style:line-style="solid" style:adjustment="left"
         style:rel-width="25%" style:color="#000000"/>
        </style:page-layout-properties>
        <style:header-style/>
        <style:footer-style/>
       </style:page-layout>
      </office:automatic-styles>
      <office:master-styles>
       <style:master-page style:name="Standard" style:page-layout-name="pm1"/>
      </office:master-styles>
     
      <office:body>
       <office:text>
        <text:sequence-decls>
         <text:sequence-decl text:display-outline-level="0" text:name="Illustration"/>
         <text:sequence-decl text:display-outline-level="0" text:name="Table"/>
         <text:sequence-decl text:display-outline-level="0" text:name="Text"/>
         <text:sequence-decl text:display-outline-level="0" text:name="Drawing"/>
        </text:sequence-decls>
        <text:p text:style-name="Standard"><text:span text:style-name="Strong_20_Emphasis">
        <text:span text:style-name="T1">Bon </text:span></text:span>
        <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T2">courage</text:span></text:span>
        <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T1"> Ã  </text:span></text:span>
        <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T3">tous</text:span></text:span>
        <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T1"> et Ã  </text:span></text:span>
        <text:span text:style-name="Strong_20_Emphasis"><text:span text:style-name="T4">toutes</text:span></text:span>
        </text:p>
     
       </office:text>
      </office:body>
     </office:document>

Le format CSV est un format texte délimité dont le séparateur par défaut est la virgule en mode EN et le point-virgule en modeFR. Le wiki anglais et le wiki français ne fournissent pas exactement les mêmes informations sur ce format :


     $gh>cat tableur_data.csv
     
     "Iden";"Longueur"
     "1906384B";110
     "1YYCA";174
     "A2XG55";33

Là encore, les formats ODS et XLSX correspondent à des archives de fichiers XML :


     @ghchu~/public_html/Webrd|(~gH) > unzip -v tableur_data.ods
     
     Archive:  tableur_data.ods
      Length   Method    Size  Cmpr    Date    Time   CRC-32   Name
     --------  ------  ------- ---- ---------- ----- --------  ----
           46  Stored       46   0% 2012-08-11 21:30 8a396c85  mimetype
         4586  Defl:N     1055  77% 2012-08-11 21:30 709917f1  content.xml
         6515  Defl:N     1495  77% 2012-08-11 21:30 5930af5f  styles.xml
          703  Stored      703   0% 2012-08-11 21:30 0ed35f21  meta.xml
         3139  Defl:N     2535  19% 2012-08-11 21:30 dc135285  Thumbnails/thumbnail.png
            0  Defl:N        2   0% 2012-08-11 21:30 00000000  Configurations2/accelerator/current.xml
            0  Stored        0   0% 2012-08-11 21:30 00000000  Configurations2/progressbar/
            0  Stored        0   0% 2012-08-11 21:30 00000000  Configurations2/floater/
            0  Stored        0   0% 2012-08-11 21:30 00000000  Configurations2/popupmenu/
            0  Stored        0   0% 2012-08-11 21:30 00000000  Configurations2/menubar/
            0  Stored        0   0% 2012-08-11 21:30 00000000  Configurations2/toolbar/
            0  Stored        0   0% 2012-08-11 21:30 00000000  Configurations2/images/Bitmaps/
            0  Stored        0   0% 2012-08-11 21:30 00000000  Configurations2/statusbar/
         7231  Defl:N      945  87% 2012-08-11 21:30 9393bb63  settings.xml
         1896  Defl:N      330  83% 2012-08-11 21:30 ff80d544  META-INF/manifest.xml
     --------          -------  ---                            -------
        24116             7111  71%                            15 files
     
     @ghchu~/public_html/Webrd|(~gH) > unzip -v tableur_data.xlsx
     
     Archive:  tableur_data.xlsx
      Length   Method    Size  Cmpr    Date    Time   CRC-32   Name
     --------  ------  ------- ---- ---------- ----- --------  ----
          571  Defl:N      224  61% 2012-08-11 21:29 b782aa66  _rels/.rels
          392  Defl:N      223  43% 2012-08-11 21:29 aae67dae  docProps/core.xml
          358  Defl:N      218  39% 2012-08-11 21:29 dc515681  docProps/app.xml
          549  Defl:N      210  62% 2012-08-11 21:29 7af9f04f  xl/_rels/workbook.xml.rels
         2610  Defl:N      970  63% 2012-08-11 21:29 54a219b2  xl/worksheets/sheet1.xml
         4425  Defl:N      671  85% 2012-08-11 21:29 9e9cee72  xl/styles.xml
          718  Defl:N      411  43% 2012-08-11 21:29 e0a08d5d  xl/workbook.xml
          270  Defl:N      186  31% 2012-08-11 21:29 d3e2279e  xl/sharedStrings.xml
         1111  Defl:N      305  73% 2012-08-11 21:29 44d373f5  [Content_Types].xml
     --------          -------  ---                            -------
        11004             3418  69%                            9 files

Pour Open Office, le «vrai» fichier est content.xml ; pour Microsoft Office, le «vrai» fichier utilise sheet1.xml et sharedStrings.xml.

XML en L2, université d'Angers

gilles.hunault@univ-angers.fr

T.P. numéro 1 : outils ligne de commandes et structuration XML

Table des matières cliquable

1. Outils logiciels en ligne de commandes

Solution : afficher la solution

2. Rendre un document HTML valide pour la grammaire XHTML 1.0 Strict

Solution : afficher la solution

3. Passer de XHTML 1.0 Transitionnel à XHTML 1.0 Strict

Solution : afficher la solution

4. Réparer des fichiers mal formés ?

Solution : afficher la solution

5. Compter des éléments et des attributs

Solution : afficher la solution

6. Attributs uniques

Solution : afficher la solution

7. XML et bureautique

Solution : afficher la solution