Saving Datapage results in Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Saving Datapage results in Excel

    When I save Datapage results in Excel, everthing the data for each reading is in on cell seperated by commas. How can I seperate the data so it will have its own cell. If this is not clear enough, is there any one out there that excels in Excel that can email me. And I will call and explain what I am trying to do.

    Thanks
    Paul
    sigpicSummer Time. Gotta Love it!

  • #2
    create a report in datapage. click File\Save to file\Save All Reports\ name it 'something.txt' go into your main Datapage folder and find the .txt file you just saved. change the file extension to .xls. and it should put the data in separate columns for you.

    Comment


    • #3
      Paul;

      In addition to the default 'tab' setting for the delimiter, I add the 'space' and 'tab' options. I also check the box to treat consecutive delimiters as one.

      Hope this helps,

      Doug Wells

      Comment


      • #4
        I use spreadsheet save then open excel and open the text file a window will open make sure delimited is checked should be ok..
        If you have a lot of header info you may want to edit it out of the text file first
        It doesn't seem to be a problem leaving it in tho
        sigpic
        if you had soap on a rope it would be tied to yer ankle

        Comment


        • #5
          It sounds like your data is comma delimited. When you open a non-excel file in excel it should ask you if your data is delimited or in fixed width columns. If you choose delimited, then you can select the delimiter - in your case it would be comma.

          Hope this helps!!
          Lenice

          Comment


          • #6
            I Save the datapage spread sheet as a .txt. (data page set up for comma seperated)
            Open exel.
            Data/external data import/ import data/ browse for saved .txt file

            text import wizard step 1
            delimited
            start import row "1"
            file Origin "437: OEM united states
            Next>

            step 2
            delimiters "Comma"
            next>

            step3
            column data format
            General
            Finish
            OK

            then I click on cell "PART"
            Click on DATA-Filter-Auto Filter

            this way I can pull data just for a specific part.
            also copy and paste that data to inspection sheet.

            I do the same import for Varible information.
            which tells me what LOC1.D is. "Datum A OD"
            2014 SP5, DataPage + v5.0 #331
            [testing v2015.1]

            Comment


            • #7
              Just save the report as xls file, example: report1.xls, then open it directly with excel.
              Global S Blue 12.15.10 HH-AS-T2.5 / HP-S-X1h |PC-DMIS CAD++|Quindos7 CAD; Leitz Reference Xi 15.9.7

              Comment

              Related Topics

              Collapse

              Working...
              X