Skip to Content
1
Jan 16, 2023 at 06:52 AM

Loading Excel (.xlsx) data using SAP PCo Query in SAP MII 15.3

385 Views

Dear Experts,

I am trying to load data from Excel through PCo Query in SAP MII.

I have configured the agent as a PCo Data Server in SAP MII and It is in a running status.

image.png

I have created an excel file (.xlsx) with some test data. Placed the file in a PCo server on a specific folder where the file monitoring source system is pointing to.

image.png

I have created a PCo query in MII workbench and trying to extract the data from Excel. I am getting an error message stating 'Character reference "" is an invalid XML character.'

image.png

Can you please help me to understand the cause for this issue.

Thanks & Regards,

Surender Kamaraj.

Attachments

image.png (76.8 kB)
image.png (34.0 kB)
image.png (85.1 kB)