XSLT transformation not reading more than one record

[kapil_thuthuku]

Hi Guys,

To upload XLSX file I have followed the document XSLX upload a unified approach written by Benu Mariantony https://archive.sap.com/kmuuid2/6026d7c0-c716-3010-c8be-ea771ff9d783/XLSX%20Upload%20-%20A%20Unified...

However I am getting only single record in the Output. Can anyone please help me?

Note: Excel upload program is called from Fiori Launchpad. As SAPGUI related function modules doesn’t work in Webgui I have followed the above approach.

Please let me know if any alternative is available.

[Jean_Sagi]

Hi Kapil, very interesting document by Mr. BENU.

Hope you get a resolution to your problem.

J.

[DoanManhQuynh · Accepted solution]

If you followed all step in that document, you will have to know there are date, time...fields in table SPFLI downloaded from SE16 to excel and auto convert into excel format ( with colon and slash ). when you re-upload that file using transformation, it wont auto translate it back to ABAP (thats make exception error and your transform failed) type so you have to rework the transformation that link gave you. 1 you can re-format your excel file, or in your transform you have to consider the date, time fields and translate it back to abap type.

[kapil_thuthuku · Accepted solution]

Thanks Quynh Doan Manh for pointing out the issue. It is working without date and time fields.

Can you please provide me the format function to handle date and time XSLT transformation?

[DoanManhQuynh · Accepted solution]

if you want to convert in inside xslt, you should go to xslt forum...there are alot of solutions there (i dont know much about xslt). if you dont famaliar with xslt, i think you should use internal table with character type field to hold the data from transform and do the convert, check in ABAP side, it could be easier.

[Sandra_Rossi]

Hopefully abap2xlsx is widely used by the community to avoid such problems.