- This topic has 3 replies, 1 voice, and was last updated 9 years, 2 months ago by
.
-
Posts
-
-
Hello Everyone
Can we have a dynamic map for the following scenario.
We receive different files having different formats like excel,text,xml etc. and we need to convert all that formats into a fixed format.
how can we convert excel sheet into xml format so that we can process that received file in biztalk server.
Thanks in advance.
-
I would create a file adapter with a filename filter for each file type using the passthrough pipeline. Likely you would have to pass it to a custom .net class to do your conversion between formats into a common, presumably xml, format. The receive msg might have to be an XmlDocument.
Alternatively you can use the FileName property to do context-based routing to the correct converter.
-
Since Excel sheets can be converted to XML, he should be able to automate this conversion with some .net base objects.
this shows there are caveats if it contains formulas, but it is a start
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=398481&SiteID=1
there are also utilities people have made
http://www.codeproject.com/csharp/Excel2XML.asp
– weak architect
-
Also check out out this from Matt Meleski (MVP):
http://objectsharp.com/blogs/matt/archive/2006/01/29/3778.aspx
And for a commercial offering:
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.