MDM API and Excel

[Former Member]

Hi All,

I'm looking for some examples of MDM API used with MS Excel. Do you know of good web logs or forums that describes a sample scenario?

I'm looking to create a repository and load some data based on a predefined excel spread sheet.

Thank you!

Roman D.

[Former Member]

Hi Roman,

I would recommend you load Excel data in SAP NetWeaver MDM using the MDM Import Manager or the MDM Data Manager's import capabilities instead. Both these options don't require you to write code.

Regards,

Richard

[Former Member]

Richard is right..... if what you are looking for is automate the process, you can use the BatchImporter, which will import data from all supported formats, without the need of human interaction.

On the other hand, Excel files can be manipulated by Java, and so MDM. Please check http://jakarta.apache.org/poi/hssf/index.html

for a Java API for Excel files. I've used it myself and it's pretty easy

Kind Regards

alejandro

[Former Member]

Hi Richard and Alejandro,

Thanks for your answers. However, the requirement is that I create a spreadsheet for some MDM functionality.

I will use HSSF library!

Regards,

Roman

[Former Member]

Hi Roman,

Could you elaborate on the HSSF library and share some more details..

Thanks,

Regards,

Tanveer.

[Former Member]

Tanveer,

Visit http://jakarta.apache.org/poi/hssf

It's an open-source JAVA library for accessing excel-type files. You can download jar files and link them to your projects.

The API also comes with downloads.

So far I've been very satisfied with it.

Thanks,

Roman D.

[Former Member]

Hey,

thanks a lot..

I shall try this out!

Regards,

Tanveer.