Create excel empty cell

[yushinchan]

Hi there,

Can anyone kindly check for me with my workflow?
Read Multiple XML.xaml (28.9 KB)

I was about to create an empty excel cell for field that the state and city from my xml file is found empty. Otherwise if the address contained both state and city, it will turns up the result writing in the excel file. But, there was an error occurred with my workflow.

I looking forwards from any reply. Thanks in advance.

[sarathi125 (Parthasarathi)]

@yushinchan,

Change that line of code as the following, always use Convert.Tostring which will handle null values. Change it to all the applicable places in your workflow.

Convert.ToString( firstAdrVal.Descendants("cty").Value)

[yushinchan]

Thanks @sarathi125, it’s work :')