Convert Excel file to xml

CloverDX Platform
1

Hi,

I have an input excel file which needs to be converted to an XML file.
The xml output is of a specific format, which has additional columns of default value, other than columns in the input xls file and also column names which are different from the input xls file.

I want to know how can we create this source to target mapping??

Hope to receive a reply soon.
Much Thanks,
Indu

2

Hello Indu,
For reading data from excel file use XLSReader. To set some columns to default value use default_value autofilling function. If you don’t need to join data from different inputs, use StructuredDataWriter for creating an xml output. In other case you need to use XMLWriter and create proper mapping.