7

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?

2
  • You can also just save a plain HTML file with a table and load that in Excel... maybe there's a style class or something you can leverage in there to achieve this?
    – Matt Lacey
    Commented Sep 12, 2012 at 4:36
  • Thanks but CSS doesn't seem to do it when it comes to freezing/locking. I have been using CSS to style cells etc.
    – baysOfHail
    Commented Sep 13, 2012 at 23:22

1 Answer 1

3

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/

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .