As a service provider we provide a service to multiple customers and channels.
This is a new requirement that we are expecting to receive from each customer a specific Excel file and send a different Excel file.
You can imagine that we could receive hundreds of different Excel files from customers.
Also, we have an integration point for each customer that we need to map the customer format file to our canonical schema.
We need to build two pipelines: one for receiving and one for sending Excel files.
For receiving we need to parse an Excel file using the configured template file to generate an xml file matching an existing customer schema as demonstrated in Figure 1
For sending, we need to convert xml file to generate an Excel file via custom sending pipeline using an existing Excel template as demonstrated in figure 2
Then we need to generate a schema depending on a template file that we built it on figure 4
I build a simple tool to generate a schema from an existing template as Figure 5 or you can create schema manually
Open your send pipeline, then add ExcelPipelineEncoder from ToolBox and drag it to Encode part as Figure 9
Now I will create one receive port as Rcv_Excel and a receive location as Rcv_ExcelLocand I will configure the Rcv_ExcelLoc as figure 11
Another important place to find an extensive of BizTalk related articles is the TechNet Wiki
itself. The best entry point is BizTalk
Server Resources on the TechNet Wiki.