471,598 Members | 1,224 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,598 software developers and data experts.

XSLT and Excel

Hi Guys,

I do need to transform some excel spreadsheets into xml files through an
automated process.
Is it possible to do it using XSLT? Could anybody give me any direction?
Cheers,

Fabio.
Dec 6 '05 #1
2 3318
Fabio,

Are the Excel sheets in XML format already? If so, then you shouldn't
have to do anything.

If not, XSLT is not going to help you. XSLT can only transform from
XML->XML, XML->Delimited text. It can't transform from/to any arbitrary
format.

What you need to do is automate excel, open the sheet, and then save it
as XML (later versions of excel will allow you to save excel as xml).

Then, you can apply an XSLT to the XML that excel outputs in order to
get the XML in the format you want.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Fabio Goncalves" <fa*****@gmail.com> wrote in message
news:us***************@TK2MSFTNGP14.phx.gbl...
Hi Guys,

I do need to transform some excel spreadsheets into xml files through an
automated process.
Is it possible to do it using XSLT? Could anybody give me any direction?
Cheers,

Fabio.

Dec 6 '05 #2
Hi Nicholas,

I really appreciate your help.

Anyway, due to high volume of incoming files, I wont be able to manually
open excel

and transform then to xml. I am gonna write an application to do this
transformation.
Regards,

Fabio.


"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:%2******************@TK2MSFTNGP10.phx.gbl...
Fabio,

Are the Excel sheets in XML format already? If so, then you shouldn't
have to do anything.

If not, XSLT is not going to help you. XSLT can only transform from
XML->XML, XML->Delimited text. It can't transform from/to any arbitrary
format.

What you need to do is automate excel, open the sheet, and then save it as XML (later versions of excel will allow you to save excel as xml).

Then, you can apply an XSLT to the XML that excel outputs in order to
get the XML in the format you want.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Fabio Goncalves" <fa*****@gmail.com> wrote in message
news:us***************@TK2MSFTNGP14.phx.gbl...
Hi Guys,

I do need to transform some excel spreadsheets into xml files through an
automated process.
Is it possible to do it using XSLT? Could anybody give me any direction?
Cheers,

Fabio.


Dec 6 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by solex | last post: by
7 posts views Thread by Doug Heeren | last post: by
1 post views Thread by =?Utf-8?B?R2xlbm4gR29tZXo=?= | last post: by
2 posts views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.