Xml/Xslt - Sample Excel Generate Using Stylus studio

Asked By dileep kumar on 08-Mar-12 07:40 AM
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
Somesh Yadav replied to dileep kumar on 09-Mar-12 01:15 AM
Hi refer to the below links,

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

http://www.ehow.com/how_7469350_xslt-html-tutorial.html
dileep kumar replied to kalpana aparnathi on 09-Mar-12 05:43 AM
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
dileep kumar replied to Somesh Yadav on 09-Mar-12 06:05 AM
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

Parag Satpute replied to dileep kumar on 09-Mar-12 03:46 PM
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.