I am trying to take an XML file and deserialize it but then to convert the output into either a CSV or Excel file. I have figured out how to deserialize the XML and write the data I want into the writelin output but I’m not sure of the best/most efficient way to then convert the output to a data table of CSV/Excel.
Bascially I have XML structure like this:
Each line has specific structured data elements as well. I have written the sequence to deserialize XML and can get the output (example below) on the writeline function:
I want to print a single excel row for all of the line level data elements for each invoice on each iteration of this sequence. Any suggestions on best way to proceed from the deserialized XML to a CSV or Excel file?
Hey @vvaidya thanks for your suggestions on this topic. I have a similar use case where I want to use this method to parse any xml file into and excel workbook. The issue I am having is when using the append range function I get a compiler error where you have table saying implicit conversions from object to system data table is not allowed. I’m confused because when I print the type of each table it says it’s a data table so wondering why it is seen as an object? Any help would be greatly appreciated.
Error ERROR Validation Error ‘DataSet’ does not have a public instance method named ‘ReadXML’ matching the parameter types, generic type arguments, and generic type constraints supplied to InvokeMethod ‘Invoke Method’.
Although all seems ok … why am i ending up with this error