on 08-24-2015 2:28 PM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please go through this
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.