Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to Import XML produced by MS-Excel?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00903822
Message ID:
00904412
Vues:
29
Thanks Sergey, that was I thinking about it. I'll ask to the provider to give the information in other format.

>It looks like Excel file saved in XML format. I doubt that XmlAdapter() can handle it but I may be wrong. The easiest way would be to load it back into Excel and save into the format that easier to process.

>Thanks Sergey, that's a little snnipet of the XML I have.
>
>
><?xml version="1.0"?>
><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">
>  <Author>grocco</Author>
>  <LastAuthor>grocco</LastAuthor>
>  <Created>2004-05-07T20:14:17Z</Created>
>  <LastSaved>2004-05-07T20:24:57Z</LastSaved>
>  <Company>PERSONAL</Company>
>  <Version>10.3501</Version>
> </DocumentProperties>
> <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
>  <DownloadComponents/>
>  <LocationOfComponents HRef="file:///D:\"/>
> </OfficeDocumentSettings>
> <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
>  <WindowHeight>10110</WindowHeight>
>  <WindowWidth>16380</WindowWidth>
>  <WindowTopX>360</WindowTopX>
>  <WindowTopY>120</WindowTopY>
>  <ProtectStructure>False</ProtectStructure>
>  <ProtectWindows>False</ProtectWindows>
> </ExcelWorkbook>
> <Styles>
>  <Style ss:ID="Default" ss:Name="Normal">
>   <Alignment ss:Vertical="Bottom"/>
>   <Borders/>
>   <Font/>
>   <Interior/>
>   <NumberFormat/>
>   <Protection/>
>  </style>
>  <Style ss:ID="s21">
>   <NumberFormat ss:Format="mm:ss.0"/>
>  </style>
> </Styles>
> <Worksheet ss:Name="Hoja1">
>  <Table ss:ExpandedColumnCount="12" ss:ExpandedRowCount="4589" x:FullColumns="1"
>   x:FullRows="1" ss:DefaultColumnWidth="60">
>   <Column ss:Index="6" ss:Width="248.25"/>
>   <Column ss:Index="9" ss:AutoFitWidth="0" ss:Width="76.5"/>
>   <Column ss:Index="11" ss:Width="76.5"/>
>   <Row>
>    <Cell><Data ss:Type="String">B-363133</Data></Cell>
>    <Cell><Data ss:Type="Number">87264</Data></Cell>
>    <Cell><Data ss:Type="Number">20021</Data></Cell>
>    <Cell><Data ss:Type="Number">20036</Data></Cell>
>    <Cell><Data ss:Type="Number">108.96</Data></Cell>
>    <Cell><Data ss:Type="String">15% PRO-CAMINOS</Data></Cell>
>    <Cell><Data ss:Type="Number">55511</Data></Cell>
>    <Cell ss:StyleID="s21"><Data ss:Type="DateTime">2004-04-29T09:08:07.160</Data></Cell>
>    <Cell><Data ss:Type="Number">530100170000</Data></Cell>
>    <Cell><Data ss:Type="Number">30260</Data></Cell>
>    <Cell><Data ss:Type="String">soniaflores</Data></Cell>
>    <Cell><Data ss:Type="String">Canaco</Data></Cell>
>   </Row>
>   <Row>
>    <Cell><Data ss:Type="String">B-363133</Data></Cell>
>    <Cell><Data ss:Type="Number">87264</Data></Cell>
>    <Cell><Data ss:Type="Number">20021</Data></Cell>
>    <Cell><Data ss:Type="Number">20036</Data></Cell>
>    <Cell><Data ss:Type="Number">108.96</Data></Cell>
>    <Cell><Data ss:Type="String">15% PRO-EDUCACION Y ASISTENCIA SOCIAL</Data></Cell>
>    <Cell><Data ss:Type="Number">55513</Data></Cell>
>    <Cell ss:StyleID="s21"><Data ss:Type="DateTime">2004-04-29T09:08:07.160</Data></Cell>
>    <Cell><Data ss:Type="Number">530100170000</Data></Cell>
>    <Cell><Data ss:Type="Number">30260</Data></Cell>
>    <Cell><Data ss:Type="String">soniaflores</Data></Cell>
>    <Cell><Data ss:Type="String">Canaco</Data></Cell>
>   </Row>
>
>....  A lot of Rows...
>....  ....
>  </table>
>  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
>   <PageSetup>
>    <Header x:Margin="0"/>
>    <Footer x:Margin="0"/>
>    <PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
>     x:Right="0.78740157499999996" x:Top="0.984251969"/>
>   </PageSetup>
>   <Selected/>
>   <TopRowVisible>484</TopRowVisible>
>   <LeftColumnVisible>3</LeftColumnVisible>
>   <Panes>
>    <Pane>
>     <Number>3</Number>
>     <ActiveRow>713</ActiveRow>
>     <RangeSelection>R714:R719</RangeSelection>
>    </Pane>
>   </Panes>
>   <ProtectObjects>False</ProtectObjects>
>   <ProtectScenarios>False</ProtectScenarios>
>  </WorksheetOptions>
> </Worksheet>
> <Worksheet ss:Name="Hoja2">
>  <Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1"
>   x:FullRows="1" ss:DefaultColumnWidth="60"/>
>  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
>   <PageSetup>
>    <Header x:Margin="0"/>
>    <Footer x:Margin="0"/>
>    <PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
>     x:Right="0.78740157499999996" x:Top="0.984251969"/>
>   </PageSetup>
>   <ProtectObjects>False</ProtectObjects>
>   <ProtectScenarios>False</ProtectScenarios>
>  </WorksheetOptions>
> </Worksheet>
> <Worksheet ss:Name="Hoja3">
>  <Table ss:ExpandedColumnCount="0" ss:ExpandedRowCount="0" x:FullColumns="1"
>   x:FullRows="1" ss:DefaultColumnWidth="60"/>
>  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
>   <PageSetup>
>    <Header x:Margin="0"/>
>    <Footer x:Margin="0"/>
>    <PageMargins x:Bottom="0.984251969" x:Left="0.78740157499999996"
>     x:Right="0.78740157499999996" x:Top="0.984251969"/>
>   </PageSetup>
>   <ProtectObjects>False</ProtectObjects>
>   <ProtectScenarios>False</ProtectScenarios>
>  </WorksheetOptions>
> </Worksheet>
></Workbook>
>
>
>
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform