XSLT Mapping To Read .XLS File

[Former Member]

Hi All,

Can anybody provide me the XSLT code to convert the incoming .xls file to xml in PI.

I know that we can read EXCEL files using the Custom adappter module as suggested in some blogs but i am looking for the other way using XSLT mapping.

Regards,

Raju.

[iaki_vila · Accepted solution]

Hi Raju,

XSLT need to work with XMLs and the Excels files are not XML, therefore you can not use the XSLT for this purpose.

Depending you PI version, Eng Swee Yeoh has developed an amazing new adapter module:

Regards.

[peter_wallner2]

Hello Raju,

I do not think you can use XSLT on a .xls file. Only on an .xlsx file which is XML. But an .xlsx file has to be unzipped in order to get the XML. See this link:

Once unzipped and you have the XML you can use an XSLT map on it.

Best regards,

Peter