Cannot use row 1 in Excel output for my header?!

  • Filter
  • Time
  • Show
Clear All
new posts

  • Cannot use row 1 in Excel output for my header?!

    Hi All,

    I would like to have my header data in row 1 in Excel. In the print command I change in "Excel output" the row of the header to "1", but when I press default and then OK, it is changed back to row 2...

    Does anyone know why I cannot change the Header row to row 1?? My other pc does not have this problem.. The version is 2017

  • #2
    Try changing it to 0 or moving the header to Row 2


    • #3
      it could be the P2X file is not being updated correctly in that version. You should have a P2X file extension with the name of the PRG file you are using. You can edit that file (via NotePad) to set the value
      HEADER ROW=1

      As a side note it seems to be OK using v2018r1.
      Last edited by SABarber; 09-17-2018, 10:08 AM.


      • #4
        It helped changing the P2X file, thank you!


        widgetinstance 190 (Related Topics) skipped due to lack of content & hide_module_if_empty option.