SSDN - How to convert XML to XLS file in XSLT for generic

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

chandrasekhar Valmiki

Subject: How to convert XML to XLS file in XSLT for generic
Author: chandrasekhar Valmiki
Date: 18 Aug 2012 09:53 PM

Hi ,

Below is the XML which i need to convert to .XLS file along with header.

<?xml version="1.0" encoding="UTF-8"?>
<ns0:MT_ZHTR1040I_Appraisal_To_Sentient_OUT xmlns:ns0="http://Axe/HTR/OU/ZHTR1040I_Appraisal_Data_To_Sentient">
<Record>
<EMPLOYEE_ID>123</EMPLOYEE_ID>
<SUPERVISOR_ID>123</SUPERVISOR_ID>
<JOB_CODE>123</JOB_CODE>
<EMAIL>chandra@gmail.com</EMAIL>
<LOCATION_CODE>750038</LOCATION_CODE>
<FIRST_NAME>chandra</FIRST_NAME>
<MIDDLE_NAME>sekhar</MIDDLE_NAME>
<LAST_NAME>valmiki</LAST_NAME>
<DOB>11/09/1977</DOB>
<RACE>indian</RACE>
<AGE>34</AGE>
<GENDER>m</GENDER>
<TARGET_BONUS>0</TARGET_BONUS>
<HIRE_DATE>09/05/2005</HIRE_DATE>
<CATEGORY_ID>temp</CATEGORY_ID>
<CURRENT_SAL>123</CURRENT_SAL>
<SALARY_DATE>11/01/2012</SALARY_DATE>
<CURRENCY_ID>123</CURRENCY_ID>
<YEARLY_HRS>123</YEARLY_HRS>
<PRORATED_SAL>123</PRORATED_SAL>
<PLAN_ELIGIBLE>123</PLAN_ELIGIBLE>
<BUDGET_AMOUNT>12.00</BUDGET_AMOUNT>
<POSITION>SR</POSITION>
<DIVISION_ID>123</DIVISION_ID>
<PAY_AREA>123</PAY_AREA>
<LAST_SAL_ACTDATE>123</LAST_SAL_ACTDATE>
<STOCK_BUDGET>123</STOCK_BUDGET>
<LIST_VIEW>123</LIST_VIEW>
<STI_BUDGET>123</STI_BUDGET>
</Record>
</ns0:MT_ZHTR1040I_Appraisal_To_Sentient_OUT>

Thanks,
Chandra.

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.