How to read xlsx files using file sender adapter in PI7.11

[Former Member]

Hi All,

i have scenario where i need to read the xlsx file and convert it into idoc.

i have gone through the few bolgs

but not got proper result to read the xlsx file.

please guide me how can i achieve this scenario using standard way(like standard adapter modules,graphical mapping).

i saw in some blogs using API....

but i am not aware of the process of develop custom modules in PI.

please if there is any step by step process document to develop custom module for adapters.

thanks in advance.

mahesh

[former_member184720]

if it is xlsx then you can make use of standard modules.

[Former Member]

HI Hareesh,

i have gone through that blog.

i tried it...but i am getting mapping error  no receiver determination fond because there are so  many excel files.

my data is available on sharedString.xml but also it is in not same order.

i have no clue how to handle this part form the blog.

"This way our mapping will receive all data from the sheet in an XML format. The only thing that's left is to create an XSD file from the XML file we received in order to be able to use it in the mapping and as our Service Interface and we can proceed with mapping. As you can see from the sheet.xml files all the data is placed with column name and row number so it's not that difficult to map it to an table type format using the Message Mapping only (no java, abap mapping required)."

[former_member184720]

Did you use the payload swap bean and gave the sheet number where your data is available?

Your data should be available under sheet1.xml right?

[Former Member]

Hi Hareesh,

Yes i have used the payload swap bean module.

still i am getting the error.

my data is not availble in sheet1.xml  but availble in sharedstring.xml sheet.

Thanks

mahesh

[Former Member]

you can build java mapping with poi jar files to read xlsx file and perform mapping. also refer the below blog