• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Excel generation to enable freeze of header row

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

  • Excel generation to enable freeze of header row

    We generate a lot of reports using Valence vvOut_execSQLtoSS or
    vvOut_toSS and our users like the flexibilty that provides. We have spent considerable effort adjusting the output format and they work great but we can't find a way to freeze the header row.

    Would it be possible provide a parameter to freeze first row? That would help greatly since users are continually adjusting this manually.

    Thinking ahead, would it be possible to pass a heading (text cell) for spreadsheet that would span the columns on the report and adopt a heading style? That would allow us to label the spreadsheet with title and other information like date or selection information like state, etc. The freeze first row would then be freeze n rows (or just 2).

Working...
X