Skip to Content
avatar image
Former Member

Excel(.xlsx) to .csv converison in SAP PI XI

Hi All,

Basically the requirement is file to file wherein the source structure is Excel format and target structure is .csv format.

Please help me with the conversion in pi7.0. Many Thanks.

SOURCE_EXCEL.jpg (34.3 kB)
gtrrr.jpg (21.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jul 03, 2015 at 10:25 AM

    Hi Rajesh,

    Please follow the Eng Swee's Blog.

    ExcelTransformBean Part 1: Convert various Excel formats to simple XML easily

    Regards,

    Suhale Shaik.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Rajesh,

      Please mention the parameter names as well like converter class etc. as suggested by Suhale from Eng Swee's blog. Let me know if it still doesn't work.

      Kind Regards,

      Souvik

  • Jul 03, 2015 at 10:54 AM

    Hi Rajesh and Suhale,

    I don't know if Eng solution will work in PI 7.0.

    You have some alternatives more:

    Excel Files - How to handle them in SAP XI/PI (The Alternatives)

    PI/XI: Reading MS Excel's XLSX and XLSM files with standard PI modules - easily...

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2015 at 05:24 AM

    Hi Experts,

    Please provide your inputs.

    Many Thanks......

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2015 at 05:47 AM

    Hi Rajesh,

    I think its better to use XSLT mapping....

    If u want to work with Excel in a file to file scenario XSLT is a best option.

    Regards,

    Srikanth Mavuri.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 06, 2015 at 10:30 AM

    Hi Rajesh,

    Please find the below blog.

    A Simple approach in Reading Excel File

    Regards,

    Sateesh.

    Add comment
    10|10000 characters needed characters exceeded