Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
5 replies Latest Post - ‏2014-04-03T10:01:23Z by KBSri
KBSri
KBSri
104 Posts
ACCEPTED ANSWER

Pinned topic Exporting the values the from the DOORS to EXCEL Sheet on the particular CELL

‏2014-03-21T09:27:16Z |

Hello All,

I need to export the values of the module data into the EXCEL template.

Consider the scenario that you are running the script  in the project folder path. Inside the EXCEL Template there is only one sheet you need to export.

The folder name (Eg: BON,NAME etc) inside the path should be exported under System Heading in the EXCEL template, next is the TEST heading inside the EXCEL where all the modules under the folder "TEST" should be updated.

The next two columns will be fetched from the attribute value (TEST RUN attribute).Same way for REQ modules too.

I have attached the Template where the data needa to be exported

I am not very sure how to export the data back to EXCEL to the specific cell.

Please help me out!

Updated on 2014-03-21T10:25:49Z at 2014-03-21T10:25:49Z by KBSri
  • KBSri
    KBSri
    104 Posts
    ACCEPTED ANSWER

    Re: Exporting the values the from the DOORS to EXCEL Sheet on the particular CELL

    ‏2014-03-24T05:04:25Z  in response to KBSri

    Can anyone please help me on this?

    • Mike.Scharnow
      Mike.Scharnow
      157 Posts
      ACCEPTED ANSWER

      Re: Exporting the values the from the DOORS to EXCEL Sheet on the particular CELL

      ‏2014-03-24T08:54:08Z  in response to KBSri

      The information how to set the value of a specific excel cell is available in the DXL help file, section ,Automation client support", command "OlePut".

      Best Regards,
      Mike

      • KBSri
        KBSri
        104 Posts
        ACCEPTED ANSWER

        Re: Exporting the values the from the DOORS to EXCEL Sheet on the particular CELL

        ‏2014-03-24T09:03:40Z  in response to Mike.Scharnow

        Hello Mike,

        Thanks. I am a newbie. Can you suggest me how to proceed because here i need to refer the particular EXCEL template.

        It would be of great help!

         

        • Mike.Scharnow
          Mike.Scharnow
          157 Posts
          ACCEPTED ANSWER

          Re: Exporting the values the from the DOORS to EXCEL Sheet on the particular CELL

          ‏2014-03-24T09:21:32Z  in response to KBSri

          I'm afraid creating a complete solution for you is out of the scope for this forum. I'm sure you can hire a DXL specialist for coaching you into DXL and OLE programming.

          As for your Excel template question: navigate to the top of this page, locate the box labeled "This forum: Search", type "Excel template" and read the second post named "How to load Excel template for exporting to excel" or the third post named "Open Excel template as a copy"

          • KBSri
            KBSri
            104 Posts
            ACCEPTED ANSWER

            Re: Exporting the values the from the DOORS to EXCEL Sheet on the particular CELL

            ‏2014-04-03T10:01:23Z  in response to Mike.Scharnow

            I require sample DXL for my project just to put the values in the particular template.

            Is that possible?

            Please help me out.

            Updated on 2014-04-03T11:01:14Z at 2014-04-03T11:01:14Z by KBSri