To read Excel file with multiple worksheets in Mail adapter to Idoc

[Hemant_Malvi]

Hello,

I am using PI version 7.4 Dual Stack SP 06.

Scenario: Mail to Idoc

We have referred the below blog:

I have enhance the Source code and try to achieve the functionality but it works only when we ignore the column name.

I am not able to see the payload in sxmb_moni (image is attached).

PFA module tab configuration and output file while testing

Regards,

Hemant

[engswee]

Hi Hemant

Since you are enhancing the module, I'd suggest that you test and debug your changes using the approach below prior to deploying it into the system.

Regards

Eng Swee

[Hemant_Malvi]

Hello Eng,

I tired enhancing the code but not successful yet. I am not a java expert so it is taking lot of time to debug and make correction.

Can you help me to enhance the module so i can achieve the functionality of reading the excel with multiple sheet and convert it to xml.

Let me know if you require any information from my end.

Regards,

Hemant Malvi

[former_member190293]

Hi Hemant!

Wouldn't you explain with more details what your problem exactly is?

Regards, Eugene.

P.S. Just at first sight: maybe your output content type must be "text/xml"?