Export to excel and freezing of columns

Posted by: nishanth83 on 8 September 2017, 1:21 pm EST

  • Posted 8 September 2017, 1:21 pm EST

    Hi,


    What is the way to set-up the grid so that the header row is frozen when we export the grid to excel. To do this for the columns, we do

    .colFrozen = 5 ( to freeze 5 columns) 

     

    Many Thanks,

     Johny

  • Replied 8 September 2017, 1:21 pm EST

    Johny -

    I'm not sure what .colFrozen is referring to.  There is no property by that name in SpreadWin.  There is a FrozenRowCount you can use for the rows.

  • Replied 8 September 2017, 1:21 pm EST

    Hi Bob,

     

    Sorry the .ColFrozen was a wrapper method and we used for Spread.ActiveSheet.FrozenColumnCount.

    I tried  FrozenRowCount = 0 but that didn't freeze the header.

    Thanks,

     Johny
     

  • Replied 8 September 2017, 1:21 pm EST

    Johny -

    I'm not really sure what you are looking for here.  Could you post a screenshot or something so I can get an idea?

  • Replied 8 September 2017, 1:21 pm EST

    Hi Bob,

     

    Here is an example. In the sheet, the first fix columns are frozen so you can scroll to the right as much as you want and the columns will always be visible. I am looking to do a similar thing where I freeze the header row - i.e. the row that contains that name of the columns.

     

    Thanks,

    Johny

     


    2008/07/excel_sheet.zip
  • Replied 8 September 2017, 1:21 pm EST

    Johny -

    There is not a way to freeze a row in the column header.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels