Find your content:

Search form

You are here

How to get Visualforce to output Excel with column freezing (panes)

 
Share

I'm trying to get a Visualforce page to output to an Excel file that contains column freeze points. Is this possible?

The "plain" Excel is working via: contentType="application/vnd.ms-excel#AccountContactsTable.xls"

But not sure how/if to do the row/col freezing/locking bit.

Anyone know-hows?


Attribution to: baysOfHail

Possible Suggestion/Solution #1

Hi I bumped into a post where they do it through asp.net maybe that can be helpful for you?

https://stackoverflow.com/questions/9185928/how-can-i-create-a-freeze-pane-in-excel-when-exporting-via-asp-net-using-xml

I know you can do it inside visual force using Jquery but that is then without the exporting to excel.

http://brentmuir.com/projects/freezeheader/


Attribution to: Sven Delporte
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/1381

My Block Status

My Block Content