Xml/Xslt - Sample Excel Generate Using Stylus studio

hi All,

i heared this is a good site to get the solution. i am very new to xslt with stylus studio.

Can anyone share steps and sample code to generate Excel spreadsheet using xslt with stylus studio

Thanks Advance.

Dileep

Hi refer to the below links,

http://www.stylusstudio.com/xsllist/200606/post60460.html

http://www.ehow.com/how_7469350_xslt-html-tutorial.html

Thanks Kalpana,

i am trying your logic (SYLK format) and here Title & Subject are hard coded element but my case it should read dynamically that element attribute value and element value.
 
  for example

      <CUST.NAME CUST.NAME="Customer Name">SANCHEZ QUINTANA M. PILAR</CUST.NAME>
      <UD_LEGAL_ADDRESS1 UD_LEGAL_ADDRESS1="Address 1 ">US1</UD_LEGAL_ADDRESS1>
      <UD_LEGAL_ADDRESS2 UD_LEGAL_ADDRESS2="Address 2 ">US2</UD_LEGAL_ADDRESS2>
      <UD_LEGAL_ADDRESS3 UD_LEGAL_ADDRESS3="Legal Address ">America</UD_LEGAL_ADDRESS3>

i want to display in the excel as below format
      Customer Name - SANCHEZ QUINTANA M. PILAR
      Address 1    -  US1
      Address 2    -  US2
      Legal Address    -   America

can you help me out

Thanks somesh,

i also tried with your given first link code but am getting this below issue when i opened the file its showing an attached error

issue excel.zip.zip

You will have to use "ODC_xlflatnr.exe" filter from Microsoft Site. Below is the link to download it,
http://download.microsoft.com/download/f/8/9/f89b7be1-eb0a-4a31-947f-b77a7809e33d/odc_xlflatnr.exe

Once you have downloaded it, you will have to use it. For in detail steps on How to do it browse to the below mentioned link,
http://msdn.microsoft.com/en-us/library/aa140055%28office.10%29.aspx

I am sure this will solve your problem.