Skip to main content
E
EndoplasmicReticulum
Participating Frequently
November 2, 2010
Question

Freezing Headers in Excel

  • November 2, 2010
  • 1 reply
  • 1483 views

I'm dumping the output of a query into an excel file using application/vnd.ms-excel in my code and I need to know if there is a way to freeze the header row so it stays at the top when the user scrolls down the list.

This topic has been closed for replies.

1 reply

ilssac
ilssac
Inspiring
November 2, 2010

Not if you are just sending CSV data with the vnd.ms-excel content type to tell the browser to send the CSV data to that application.

POSSIBLY if you where to use the POI and|or CF9 <cfspreadsheet...> tag.  But I would not be surprised if an Excel User Interface detail like that is something that is NOT exposed to either of those Application Interfaces.

-
-__cfSearching__-
Inspiring
November 2, 2010

Yes, you would need to create a true spreadsheet. But it is possible with with either CF9 (or earlier using POI)

http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WS89BB5273-80BA-4c55-9862-4D9D0ADA062B.html

http://poi.apache.org/spreadsheet/quick-guide.html#Splits

-Leigh

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices