Extract Excel, save as Excel

Home Page Forums BizTalk 2004 – BizTalk 2010 Extract Excel, save as Excel

Viewing 1 reply thread
  • Author
    Posts
    • #20429

       Hi,

      I want to be able to extract an Excel attachment from email and then save this to a folder on my hard drive as the Excel file, all via Biztalk 2006.

      The following link suggests how to extract the file, but does not say how to save it to a different location as Excel. Can anyone help?http://www.biztalkgurus.com/media/p/15562.aspx

      Much appreciated, thanks.

    • #20431

      Can you give some more details about the issue you’re having?  I haven’t done this before, but I think the process would be something like this:

      1. Receive email w/ Excel attachment via POP3 adapter.

      2. Use a receive pipeline to extract the attachments from the email.  The attachments are additional message parts.  You may need to write a custom pipeline component to do this.

      3. Connect  a file send port to the email receive port using filter expressions.  Configure the file mask with a “.XLS” or “.XLSX” extension, so that the files will have the correct extension.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.