cancel
Showing results for 
Search instead for 
Did you mean: 

How to read .xlsx file into sap pi

Former Member
0 Kudos

Hi Experts ,

I am working one scenario like excel file to idoc.we have to read the excel file(.xlsx) from a shared directory.The excel file contains several sheets.

from one of the sheet we have header and item details.

From that sheet i need to read the data and sheet has cells and columns. Attached the test file.

Header

Ship To

Name

PO Name

Pricing Date

PO Date

Order Reason

Item details

Material code

Order quantity

UOM

Please check the below requirement and read from the sheet (cells and columns)

HEADER DATA

ship To read from cell C1

PO number read from cell C3

date read from cell C4

orderreson read from cell C5

podate read from cell C6

LINE ITEM DATA

Start to read from row 9

End of read row 30

Only read the rows where the row having value in column B > 0 and value in column D > 0, else don’t read

1 row equal 1 line item in the sales order

Material code read in column B

Order quantity read in column D

Unit of Measure read dynamically according to column E:

If column E = CS then Unit of measure for the row is CS (cases)

1) is there any Excel TransformBeam to convert various Excel format to simple XML

2) module parameters in communication channel

2 )any java mapping

Please help me on the above requirement.


Regards,

Ganga.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member184720
Active Contributor
0 Kudos

Have a look into the below blog

Find out the corresponding xml file for the sheet that contains your data then handle your mapping requirements using java mapping.

sateesh_adma
Participant
0 Kudos