Excel question

Viewing 0 reply threads
  • Author
    Posts
    • #18900

      Hi everyone.

      I have an orchestration that uses a pop3 adapter to strip attachments off an email and saves them into a temp folder.  I have a receive Excel pipeline on that temp folder that parses the Excel files to XML.  It works great when you know the worksheet name.

      The Excel Pipeline has the sql statement to get the data off the Excel Worksheet (i.e. select * from [Sheet1$])  In this particular case, there are 9 attachments (spreadsheets).  Does any one know a way to select * from the worksheets without knowing the worksheet name?

      Thanks in advance

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