This blog explains how to convert .xls to Xml file in BizTalk using Custom Pipeline. Below pipeline component is generic one, which can be applied to any excel files for xml conversion. Sample Input (Excel File): Sample Output (Xml File): Please follow below steps. Take a class library project and keep the code mentioned in…
Sometimes we require to add some element, tag, DocType in incoming or outgoing message from BizTalk. We can achieve this by using custom pipeline. But we should use this pipeline component in Decode or encode stage of Pipeline. In this sample custom pipeline, we convert the message in string. So you can take this code…