I have a requirement to take excel file as input and convert it into pipe delimited flat file . Is this possible using Biztalk 2006 R2 ?
The excel file would ideally have number of columns around 40
If not Is it possible to convert all the data in the excel file to XML format ?
If some one has encountered such a requirement pls let me know , how to go about this.
Check the following BizTalkGurus blog for more information:
"Google skills are more important than your coding skills."
I implemented a process recently to receive an excel file from a file receive location, convert this to xml and then map this xml to a flat file schema (pipe delimited).
To do this I used a Custom Pipeline Component for Processing DBF, Excel and other ODBC types as developed by Matt Meleski.
Using this component I created a pipeline that I applied to the receive location that read in the excel file.
Then I tested it out, with an appropriate send port, to get an example of the xml output. I used this to create a schema for the excel-xml message.
I then mapped from this excel-schema to my previously created flat file schema.
Implementing the appropriate configuration resulted in a process that did the following:
The temporary location send/received is require so that the excel-xml will have the required context properties to allow the map to be invoked on the final send port.
Hope that helps.
Hi Stuart ,
Thanks a looot :) , This is too cool , I was able to use the method you suggested and read the excel file and convert to XML :) .
The process after that I guess I can handle .. Thanks again for your reply ..
Great! Yes, it is possible to use the certain methods to read excel and do more excel conversions, like metioned Excel to XML. And besides these available resource, we also can easily find a online third party that can offer the options to read and view excel document on windows or web applications, as well as convert excel document into other documment and image files.