Creating an XML Schema for an excel file

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Creating an XML Schema for an excel file

Viewing 2 reply threads
  • Author
    Posts
    • June 4, 2010 at 4:29 AM #24887
      community-content

        I want to create a Schema for an Excel File.

        I tried it using the Flat File Schema Wizard for relative positions, but am getting all kinds of weird characters on the screen.

        Kindly suggest a way by which the schema could be done.

         

      • June 4, 2010 at 8:37 AM #24891
        community-content

          Hi,

           

             You are probably better off using this commercial solution:

          http://www.fpoint.com/biztalk/default.aspx

           

             Daniel.

           

        • June 6, 2010 at 6:22 AM #24898
          community-content

            You can write Disassembler for BizTalk receive pipeline to receive excel file and write the code to read excel data. I am not sure whether there are other ways than using excel oledb component. If you want to follow this way, you need to make some logic to link your excel file to OLEDG datasource (probably another replica of excel file). However this is really difficult to maintain in case of concurrency.

            PS: There is one solution to receive/send excel in BizTalk but you will need to pay for this. click here to see, also you can download the trial version if you feel okay.. I am not sure how it works internally though.
            Another alternative is to create some services (windows service) to convert .xls file to .csv or directly xml and drop into the biztalk receive location.
            Or If it is possible to receive csv files/text file/xml file directly, this is the great way in my view.

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