How to extract fields from Excel Sheet and fetch to BAPI and BDC.

[Former Member]

Hi Gurus,

My scenario is to extract data fields from an Excel Sheet and to fetch that information to BAPI and BDCs. Can u guide me how to achieve this scenario using SAP PI 7.1 EHP 1.

Thanks in Advance.

[Former Member]

Thanks gurus,

Can u guide me on the usage of Content Conversion

[Former Member]

Hi nav,

You can read Excel file using module beans. Check this link http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/12/06/pixi-reading-ms-excels-xlsx-and-x...

Regards,

Praveen

[Former Member]

is it fixed fields within the spreadsheet?

or you could try this: