This tutorial provides a simple scenario to demonstrate how the Message Broker .NETCompute node can use the Open XML SDK API to interact with Microsoft Excel. A broker message flow receives an input XML file and records the hierarchy of the data into a Microsoft Excel spreadsheet. The flow parses the input file using the Broker's XMLNSC parser, so any well-formed XML input is acceptable. Having received and parsed the data, the message flow uses C# code within a .NETCompute node in order to update a Microsoft Excel spreadsheet. It records the broker's logical tree structure, which is the internal message broker representation of a message.
If you are experienced with the broker, the data written into the spreadsheet will look very similar to the output of a trace node when recording the logical message tree. Each row of the spreadsheet describes an element, recording its namespace, name, value, and the data type of the value. The spreadsheet document is written to a directory on the file system by the .NETCompute node, and then the message flow File Output node copies the original input xml structure into an output file.