convert the XLS file into XML format (BMECAT and EClass).

[Former Member]

Hi

I want to convert the XLS file into XML format (BMECAT and EClass).

Pl give me the procedure .

Answers will be rewarded.

Thanks & Regards

Subramanian.

[Former Member]

Hi,

Please go to the ALTOVA site and see the procedure.

All the best.

Please award the points if it helps.

Vijay Mittal

[Former Member]

I want the output in BMEcat (xml format) to upload supplier content in the MDM server.

[Former Member]

Hi,

I do not know if you have the format in XLS with the following columns.

code

description

parent

If you only have code and description you can aplly this macro to your xls-sheet and run it.

it will then write the parent i column 3

This macro is valid for UNSPSC and eCLASS and maybe for BMECAT as well. I do not know that classification. However, with a few modifications to the macro it might work or maybe without any mod 🐵

Sub UNSPSC()

Dim row As Long

row = 1

Do While Cells(row, 1) <> Empty

If Right(Cells(row, 1).Value, 6) <> "000000" Then

If Right(Cells(row, 1).Value, 4) <> "0000" Then

If Right(Cells(row, 1).Value, 2) <> "00" Then

Cells(row, 3).Value = Format(Left(Cells(row, 1).Value, 6)) + "00"

Else

Cells(row, 3).Value = Format(Left(Cells(row, 1).Value, 4)) + "0000"

End If

Else

Cells(row, 3).Value = Format(Left(Cells(row, 1).Value, 2)) + "000000"

End If

End If

row = row + 1

Loop

End Sub

[Former Member]

Hi

Do you want to save the file programmatically or directly using MS Excel. Which MS Excel version are you using ?

I tried it is working on my system.

<u>Microsoft Excel 2002 (10.6501.6804) SP3 supports this feature.

You can save any .xls file to .xml file, by slecting Save As -> (Filetype(Save as type) -> .xml (XML spreadsheet).</u>

Do let me know.

Regards

- Atul

[Former Member]

Any updates please

Regards

Subramanian.