Unable to read accent character in a generated xml file

[Benoit Sevigny]

Hi Everybody !!!

I had generated a xml file that contained accent character. When I am
trying to open it inside Excel 2002, Excel don't want to open it. If I
delete all my accent character and I am able to open it. I sent you the
content of my xml file. If you can tell me what is wrong with it it will
help me a lot. Thanks a lot !!!

<?xml version='1.0'?> <Workbook
xmlns='urn:schemas-microsoft-comffice:spreadsheet'
xmlns='urn:schemas-microsoft-comfficeffice'
xmlns:x='urn:schemas-microsoft-comffice:excel'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:ss='urn:schemas-microsoft-comffice:spreadsheet'
xmlns:html='http://www.w3.org/TR/REC-html40'>
<DocumentProperties xmlns='urn:schemas-microsoft-comfficeffice'>
<Version>10.6762</Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns='urn:schemas-microsoft-comfficeffice'>
<DownloadComponents/>
<LocationOfComponents HRef='file:///\'/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns='urn:schemas-microsoft-comffice:excel'>
<WindowHeight>10005</WindowHeight>
<WindowWidth>10005</WindowWidth>
<WindowTopX>120</WindowTopX>
<WindowTopY>135</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID='Default' ss:Name='Normal'>
<Alignment ss:Vertical='Bottom'/>
<Borders/>
<Font ss:FontName='Times New Roman'/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID='s21'>
<Alignment ss:Horizontal='Center' ss:Vertical='Top'/>
<Borders/>
<Font ss:FontName='Palatino Linotype' x:Family='Roman' ss:Size='14'
ss:Color='#000000' ss:Bold='1' ss:Italic='1'/>
<NumberFormat ss:Format='@'/>
</Style>
<Style ss:ID='s22'>
<Alignment ss:Horizontal='Center' ss:Vertical='Top'/>
<Borders/>
<Font ss:FontName='Palatino Linotype' x:Family='Roman' ss:Size='14'
ss:Color='#000000' ss:Bold='1' ss:Italic='1'/>
</Style>
<Style ss:ID='s23'>
<Alignment ss:Vertical='Top'/>
<Borders/>
<Font ss:FontName='Palatino Linotype' x:Family='Roman' ss:Color='#000000'/>
</Style>
<Style ss:ID='s24'>
<Alignment ss:Horizontal='Center' ss:Vertical='Top'/>
<Borders>
<Border ssosition='Bottom' ss:LineStyle='Continuous' ss:Weight='1'
ss:Color='#C0C0C0'/>
</Borders>
<NumberFormat ss:Format='@'/>
<Font ss:FontName='Palatino Linotype' x:Family='Roman' ss:Color='#000000'
ss:Bold='1'/>
<Interior/>
</Style>
</Styles>
<Worksheet ss:Name='Liste des acquisitions'>
<Table ss:ExpandedColumnCount='9'
ss:ExpandedRowCount='3'
x:FullColumns='1'
x:FullRows='1' ssefaultColumnWidth='54'>
<Column ss:Width='100.5'/>
<Column ss:Width='78'/>
<Column ss:Width='54.75'/>
<Row ss:Height='22.5'>
<Cell ss:MergeAcross='8' ss:StyleID='s21'><ssata ss:Type='String'
xmlns='http://www.w3.org/TR/REC-html40'><B><I> <Font
html:Color='#000000'>2005/09/01 au2005/10/28</Font></I></B></ssata></Cell>
</Row>
<Row ss:Height='15'>
<Cell ss:StyleID='s24'><Data ss:Type='String'>Fournisseur</Data></Cell>
<Cell ss:StyleID='s24'><Data ss:Type='String'>Mandat</Data></Cell>
<Cell ss:StyleID='s24'><Data ss:Type='String'>Mode Octroi</Data></Cell>
<Cell ss:StyleID='s24'><Data ss:Type='String'>Montant</Data></Cell>
<Cell ss:StyleID='s24'><Data ss:Type='String'>NoEng</Data></Cell>
<Cell ss:StyleID='s24'><Data ss:Type='String'>Annee</Data></Cell>
<Cell ss:StyleID='s24'><Data ss:Type='String'>Mois</Data></Cell>
<Cell ss:StyleID='s24'><Data ss:Type='String'>Intervenant</Data></Cell>
<Cell ss:StyleID='s24'><Data ss:Type='String'>Direction</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type='String'> Andrei Technologies Inc.</Data></Cell>
<Cell><Data ss:Type='String'>Équipements de radiocommunication, de
télévision sauf pour aéronefs.</Data></Cell>
<Cell><Data ss:Type='String'>gré à gré</Data></Cell>
<Cell><Data ss:Type='Number'></Data></Cell>
<Cell><Data ss:Type='String'>17264027</Data></Cell>
<Cell><Data ss:Type='String'>2003</Data></Cell>
<Cell><Data ss:Type='String'>01</Data></Cell>
<Cell><Data ss:Type='String'>Luc Sauvé</Data></Cell>
<Cell><Data ss:Type='String'></Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns='urn:schemas-microsoft-comffice:excel'>
<PageSetup>
<Layout x:Orientation='Landscape'/>
<Header x:Margin='0.4921259845'/>
<Footer x:Margin='0.4921259845'
xata='&D&"Palatino Linotype,Normal"&8Page &P'/>
<PageMargins x:Bottom='0.984251969' x:Left='0.78740157499999996'
x:Right='0.78740157499999996' x:Top='0.984251969'/>
</PageSetup>
<Selected/>
<TopRowVisible>2</TopRowVisible>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>4</ActiveRow>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>

 

[exceluserforeman]

Maybe open the html in browser the select all then paste into excel or try my
webpagetablemaker / importer at:
http://www.geocities.com/excelmarksway