One Star

xml and xsl to excel file.

Hello
I use Talend Open Studio 5.0
I have an xml and xsl file and want to get a excel file.
Is it possible to do this?
Who can I do this?
Regards,
Oscar Manso
11 REPLIES
One Star

Re: xml and xsl to excel file.

hola
I need an answer
Regards,
Oscar Manso
One Star

Re: xml and xsl to excel file.

I beloved using a Create a excel using xlst. Link:http://www.techrepublic.com/article/convert-an-xml-file-into-an-excel-spreadsheet-with-this-technique/6163451
S here the simplest solution I can think of is
1.do a transformation for mapping field to the style sheet
2.using streams write the file as excel
It would also be nice if you package this as plugin and put it in talend forge. Smiley Happy =)
One Star

Re: xml and xsl to excel file.

I belive using a Create a excel using xlst. Link:http://www.techrepublic.com/article/convert-an-xml-file-into-an-excel-spreadsheet-with-this-technique/6163451
S here the simplest solution I can think of is
1.do a transformation for mapping field to the style sheet
2.using streams write the file as excel
It would also be nice if you package this as plugin and put it in talend forge. Smiley Happy =)
One Star

Re: xml and xsl to excel file.

hello
I don´t undestander you soluction
who do yo this in Talend?
Regards,
Oscar Manso
One Star

Re: xml and xsl to excel file.

Do you mean you want to create a csv file from xml using xslt?
One Star

Re: xml and xsl to excel file.

Hello
Yes, but I don´t create csv file.
I want to create xls file from xml using xslt.
What is the XSLT file format?
Regards,
Oscar Manso
One Star

Re: xml and xsl to excel file.

Why use xslt? You could use Talend components to convert xml to excel.
One Star

Re: xml and xsl to excel file.

Hello
I need to use xslt to excel file is formatted for color, font ...
Regards.
Oscar Manso
One Star

Re: xml and xsl to excel file.

One Star

Re: xml and xsl to excel file.

Hello
Your response still does not serve me.
On the other hand I already visit your site
I have seen that there tXslt component. Can you help me to do what I want?
Regards,
Oscar Manso
One Star

Re: xml and xsl to excel file.

Why can't you just open the xml file in Excel? The xml just needs the xslt style sheet associated with it.
E.G. <?xml-stylesheet type="text/xsl" href="spreadstyle.xsl"?>