Connecting Tech Pros Worldwide Forums | Help | Site Map

Read Excel 2003 XML file and save as an Excel 97 file

Juliano.net
Guest
 
Posts: n/a
#1: Aug 11 '06
How can I read an Excel 2003 XML Spreadsheet and save it as an Excel 97
file?


chanmm
Guest
 
Posts: n/a
#2: Aug 12 '06

re: Read Excel 2003 XML file and save as an Excel 97 file


Try DOM:
http://msdn2.microsoft.com/en-us/lib...ldocument.aspx

But it should be easier if you are doing it in VBA than C# if you do not
have VSTO.

chanmm

"Juliano.net" <juliano.net@gmail.comwrote in message
news:1155333424.680942.144360@m79g2000cwm.googlegr oups.com...
Quote:
How can I read an Excel 2003 XML Spreadsheet and save it as an Excel 97
file?
>

Nicholas Paldino [.NET/C# MVP]
Guest
 
Posts: n/a
#3: Aug 12 '06

re: Read Excel 2003 XML file and save as an Excel 97 file


This isn't going to work, since:

a) not all Excel 2003 files are saved as xml
b) even if it was saved as XML, you don't know how to write the files back
to a native excel format


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

"chanmm" <chanmmn@hotmail.comwrote in message
news:OcrxdohvGHA.5088@TK2MSFTNGP06.phx.gbl...
Quote:
Try DOM:
http://msdn2.microsoft.com/en-us/lib...ldocument.aspx
>
But it should be easier if you are doing it in VBA than C# if you do not
have VSTO.
>
chanmm
>
"Juliano.net" <juliano.net@gmail.comwrote in message
news:1155333424.680942.144360@m79g2000cwm.googlegr oups.com...
Quote:
>How can I read an Excel 2003 XML Spreadsheet and save it as an Excel 97
>file?
>>
>
>

Nicholas Paldino [.NET/C# MVP]
Guest
 
Posts: n/a
#4: Aug 12 '06

re: Read Excel 2003 XML file and save as an Excel 97 file


You will have to load it into Excel and then call the Save method on the
worksheet. There is a parameter for the method that takes an enumeration
value indicating what version of excel to save it for.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

"Juliano.net" <juliano.net@gmail.comwrote in message
news:1155333424.680942.144360@m79g2000cwm.googlegr oups.com...
Quote:
How can I read an Excel 2003 XML Spreadsheet and save it as an Excel 97
file?
>

Nicholas Paldino [.NET/C# MVP]
Guest
 
Posts: n/a
#5: Aug 12 '06

re: Read Excel 2003 XML file and save as an Excel 97 file


I just re-read the original post, and while a doesn't apply here, b
certainly does.


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

"Nicholas Paldino [.NET/C# MVP]" <mvp@spam.guard.caspershouse.comwrote in
message news:%23NqqRSivGHA.2260@TK2MSFTNGP03.phx.gbl...
Quote:
This isn't going to work, since:
>
a) not all Excel 2003 files are saved as xml
b) even if it was saved as XML, you don't know how to write the files back
to a native excel format
>
>
--
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com
>
"chanmm" <chanmmn@hotmail.comwrote in message
news:OcrxdohvGHA.5088@TK2MSFTNGP06.phx.gbl...
Quote:
>Try DOM:
>http://msdn2.microsoft.com/en-us/lib...ldocument.aspx
>>
>But it should be easier if you are doing it in VBA than C# if you do not
>have VSTO.
>>
>chanmm
>>
>"Juliano.net" <juliano.net@gmail.comwrote in message
>news:1155333424.680942.144360@m79g2000cwm.googleg roups.com...
Quote:
>>How can I read an Excel 2003 XML Spreadsheet and save it as an Excel 97
>>file?
>>>
>>
>>
>
>

Closed Thread