Multiple Sheet Excel Form Report

  • Filter
  • Time
  • Show
Clear All
new posts

  • Multiple Sheet Excel Form Report

    Hello and thanks in advance. I just started working with PC-DMIS 2019 R1 and tried to use the Excel Form Report. Watching the short company video I was able to get it to output all my dimensions to a custom Excel sheet that I put in the Templates folder.

    I have 3 sheets in this Excel file. The 1st sheet lists all the data. The 2nd sheet contains formulas that populate cells after reading data from the 1st sheet. The 3rd sheet contains a macro that further evaluates the data (pass or fail) from the 2nd sheet.

    My problem is the PC-DMIS Excel Form Report only populates the 1st sheet with my data (or at least as far as I can see) because when I open the 2nd Sheet (Evaluation Sheet) or the 3rd Sheet (Non-Conformance Sheet) they both start with rows 1 and 2 then skip all the way down to rows 502, 503, etc...

    Is there a way to correct this or open those sheets so that I can see if rows 3 thru 501 populated with anything? Any help is greatly appreciated.

  • #2
    I use PC-DMIS 2015.1 so I'm not sure if this is the issue or not, but when I output to Excel from PC-DMIS, it imports the data as text, not as numbers. If you try to do any sort of function on a cell with a number in it that is formatted as text, it will not work. I had to use the VALUE() function in Excel to convert from text to a number. Then everything in my sheets worked properly. HINT: Text is left-aligned in the cell, Numbers are right-aligned in the cell. So if the numbers you are trying to work with are left-aligned, try using VALUE() and it should work!


    • #3


      Related Topics


      • rgarren
        PC-DMIStoExcel_auto "fill color"
        by rgarren
        I am using the above titled method to download data from PC-DMIS to excel. After doing some data cleanup, like adding dimension numbers, (which somehow...
        12-07-2006, 11:18 AM
      • Tested
        Excel sheet
        by Tested
        I have a excel sheet that is set up to bring my data from PC-DMIS in one run at a time. All seemed to be working good until this morning. Now it is alternating...
        04-04-2007, 09:20 AM
      • Mase18
        PCDMIS data to Excel
        by Mase18
        Is there a way to dump the data from my program into a specific excel sheet (one that I created)?
        05-24-2019, 07:39 AM
      • B. Jacobs
        PC-DMIS to EXCEL
        by B. Jacobs
        I know this has been covered. I have just downloaded the files from the Wilcox site and have got it to work.
        The question I have is: How do you...
        08-23-2006, 09:37 AM
      • dccfreak
        Excel Output Sheet
        by dccfreak

        I have been working for some time to get an Excel output sheet that actually went to a format that needed very little if any formatting...
        05-02-2006, 09:30 AM