Excel File Properties retrieval

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Excel File Properties retrieval

Viewing 2 reply threads
  • Author
    Posts
    • January 17, 2007 at 2:42 AM #17260
      community-content

        hi all,

        how can i get the custom properties of excel file in biztalk. like author,comments……based upon this properties routing is depends.

         

        Thanks in Adavance 

         

      • January 17, 2007 at 4:04 AM #17263
        community-content

          Anon,

          as far as I know you have to use the Office API to get this info. There is nothing, out of the BizTalk box, which retrieves this info – lots of file metadata – but not specific to Excel.

          So, either you preprocess the file to extract the metadata and then pass that to BizTalk, or you write a custom adapter which does that. Writing an adapter is not something a beginner should consider doing lightly.

          John D.

        • January 18, 2007 at 3:46 PM #17309
          community-content

            That's probably right, but what version of Excel document do you have?  I've seen a lot of custom work in the past using XML to represent Office metadata, but also, perhaps a conversion to an XML version of the document could help.  Just a simple suggestion from the hip.  I'd have to try it before I'd stand behind it though. 🙂

        • Author
          Posts
        Viewing 2 reply threads
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.