Originally posted by: wtx_genie

Hi, I have a requirement to translate .xls to .xml.

.xls contains 120 fields on sheet1 / Tab1 and 70 fields on sheet2 / Tab2.

All these fields are to be mapped into one xml target file.

Please let me know, how to achieve this scenario? Need more info on DDQuery function with samples if any?

thanks in advance,

Regards,

WTXgenie

Originally posted by: Arun Ramamurthy

Hi,

Have you looked into the WTX docs and the Install folder ? There is information on using the DDEQuery in the docs , please review the below link:

http://www-01.ibm.com/support/knowledgecenter/#!/SSVSD8_8.4.1/com.ibm.websphere.dtx.funcexp.doc/references/r_funcs_express_DDEQUERY.htm?cp=SSVSD8_8.4.1%2F21-10-3

It talks about the syntax with some examples.

Also the WTX Install folder has a DDQUERY exmaple where it demonstrates the usage of the DDEQUERY function to get information from an EXCEL spreadsheet.The example if WTX has been installed with custom option would be under C:\IBM\WebSphere Transformation Extender 8.4.1\examples\general\ddequery

Also as an other option you could look into reading the Excel spreadsheet as a database and accessing it with a ODBC adapter. The below technote discusses briefly on this option.

http://www-01.ibm.com/support/docview.wss?uid=swg21622292

For the XML output , you can try and use the schema directly for the type tree or import a tree from the schema and use it.

Hope this helps. If you are still having an issue, I suggest opening a PMR .

Thanks,

Originally posted by: Traductor PEMT

Check: http://www-01.ibm.com/support/docview.wss?uid=swg21622292