Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Unable to read accent character in a generated xml file
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Benoit Sevigny
 
Posts: n/a
Default Unable to read accent character in a generated xml file
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-com:office:spreadsheet'
xmlns:o='urn:schemas-microsoft-com:office:office'
xmlns:x='urn:schemas-microsoft-com:office:excel'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
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'
<Version10.6762</Version
</DocumentProperties
<OfficeDocumentSettings xmlns='urn:schemas-microsoft-com:office:office'
<DownloadComponents/
<LocationOfComponents HRef='file:///\'/
</OfficeDocumentSettings
<ExcelWorkbook xmlns='urn:schemas-microsoft-com:office:excel'
<WindowHeight10005</WindowHeight
<WindowWidth10005</WindowWidth
<WindowTopX120</WindowTopX
<WindowTopY135</WindowTopY
<ProtectStructureFalse</ProtectStructure
<ProtectWindowsFalse</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 ss:Position='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' ss:DefaultColumnWidth='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'<ss:Data 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</ss:Data</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-com:office:excel'
<PageSetup
<Layout x:Orientation='Landscape'/
<Header x:Margin='0.4921259845'/
<Footer x:Margin='0.4921259845'
x:Data='&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/
<TopRowVisible2</TopRowVisible
<Panes
<Pane
<Number3</Number
<ActiveRow4</ActiveRow
</Pane
</Panes
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
</Workbook
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
exceluserforeman
 
Posts: n/a
Default Unable to read accent character in a generated xml file
Maybe open the html in browser the select all then paste into excel or try my
webpagetablemaker / importer at:
http://www.geocities.com/excelmarksway



"Benoit Sevigny" wrote:

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-com:office:spreadsheet'
xmlns:o='urn:schemas-microsoft-com:office:office'
xmlns:x='urn:schemas-microsoft-com:office:excel'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
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'
<Version10.6762</Version
</DocumentProperties
<OfficeDocumentSettings xmlns='urn:schemas-microsoft-com:office:office'
<DownloadComponents/
<LocationOfComponents HRef='file:///\'/
</OfficeDocumentSettings
<ExcelWorkbook xmlns='urn:schemas-microsoft-com:office:excel'
<WindowHeight10005</WindowHeight
<WindowWidth10005</WindowWidth
<WindowTopX120</WindowTopX
<WindowTopY135</WindowTopY
<ProtectStructureFalse</ProtectStructure
<ProtectWindowsFalse</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 ss:Position='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' ss:DefaultColumnWidth='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'<ss:Data 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</ss:Data</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-com:office:excel'
<PageSetup
<Layout x:Orientation='Landscape'/
<Header x:Margin='0.4921259845'/
<Footer x:Margin='0.4921259845'
x:Data='&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/
<TopRowVisible2</TopRowVisible
<Panes
<Pane
<Number3</Number
<ActiveRow4</ActiveRow
</Pane
</Panes
<ProtectObjectsFalse</ProtectObjects
<ProtectScenariosFalse</ProtectScenarios
</WorksheetOptions
</Worksheet
</Workbook
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I unlock FILE access? rcmodelr Excel Discussion (Misc queries) 7 November 12th 05 09:55 PM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 08:21 AM
Read only error messagfe on file that was previously saved and ope Firemedic395 Excel Discussion (Misc queries) 1 December 8th 04 04:07 PM
cannot save file - folder is read only BigDog Excel Discussion (Misc queries) 1 December 7th 04 11:18 PM
Network access to file - read only property AL Excel Discussion (Misc queries) 1 December 2nd 04 01:22 AM


All times are GMT +1. The time now is 08:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement