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…
Microsoft provides lots of feature in BizTalk Pipeline with having inbuild pipeline components. E.g. JSON Encoder, Decoder, MIME/SMIME Decoder etc. But sometimes we need add something in context of message then we need to do customization in pipeline, BizTalk provides the facilities to customise with help of Custom pipeline. C# and VB.Net languages are basically…