Embedded Excel Spreadsheet

Question

I have an Excel spreadsheet embedded in a website.  My original spreadhseet has the top row frozen.  However, when viewed on the website it is not.  Is there a way to make this work?

Answer 1

Hi,

It seems you have converted excel file to html and are hosting it on website (within iframe?).

There are various ways you can achieve freezing of top row however it is not one of the easiest task. I spent a month finding the right way out and finally zero down on javascript & css I got from the web (Option A).

FREE OPTIONS...

A) The Freeze Pane DataGrid

http://www.codeproject.com/KB/webforms/FreezePaneDatagrid.aspx

• here you will have to edit existing html file by converting table to datagrid (using ID tag) and then use javascript & css.
• multiple scripts are available on net, search for "html freeze table header" on the net

B) Office 2003 Add-in: Office Web Components

http://www.microsoft.com/download/en/details.aspx?id=22276

• if the file is in excel 2003 or lower version, you can use this

C) Office Web Apps

http://blogs.msdn.com/b/officewebapps/

• For Excel 2007 & above. You need sharepoint license to use this.

D) Using Online Office services

http://docs.google.com/

http://www.officelive.com/en-us/

• Host excel files on either of this website and get embedding code for your website. Here excel file will be in public domain.

E) Use ExtJs library for Grid locking

http://dev.sencha.com/deploy/ext-4.0.0/examples/grid/locking-grid.html

• You will get looks similar to excel but formatting can't be retained. Its free for personal use.

PAID OPTIONS

If you're ready to shell out money then based on the programming platform you can buy plugins

F) Spread for .NET Bundle

http://www.fpoint.com/netproducts/spreadnet/spreadnet.aspx

G) Spread.NET 6

http://www.gcpowertools.com/products/SpreadNET

And much more... paid option.