Uploading of .xml file to system issue

Help Studio
1

Hi there,

I am reading a datatable from .xlsx and use write range activity to write selected columns in another .xlsx which than will be converted to .xml and uploaded into system. However i realise if the column is empty from datatable and when it write range in the empty column, it appear to containt > this symbol after uploading to system. Not sure what is the reason for this.

2

@mark_rajkumar1

May be that is added while converting to xml file

Can you check that

Cheers

3

Hi @mark_rajkumar1 ,

This is happening because Excel not able to find any data to be converted/saved in XML format.

You can check for if any data available for the filters, if available then only create/save the xml from Excel.

Else you can create a xml which is expected in case of no data available.

Thanks,
Ashok :slight_smile:

4

Hi @ashokkarale and @Anil_G i am using write range activity to write individual column where some row in the column will be blank but it return with symbol “>”. I am using if condition ti state if string null or empty bully however this symbol still appears which is not visible excel.