fixed columns in excel

[swellerb]

Is it possible to generate an excel spreadsheet with fixed rows and columns? I would like to have headers that don't move when you scroll down and also have the first few columns fixed when scrolling the rest of the columns to the right. Ideally I would like to render a gridview with an option to generate an excel spreadsheet with the above options. Is this possible? Thank you.

[Melba Winshia]

Hi Swellerb,

Thanks for your interest in Essential XlsIO.

Issue 1: (Is it possible to generate an excel spreadsheet with fixed rows and columns)
--------

In Excel, every workbook has 256 columns and 65,526 rows. These values are fixed and cannot be changed.

Issue 2: (headers that don't move when you scroll down and also have the first few columns fixed)
--------

You can achieve this by using FreezePane property. Here is the code snippet to achieve this:

/Applying freezing pane in the sheet by specifying a cell
sheet.Range["B2"].FreezePanes();

Here is the sample for your reference:

http://websamples.syncfusion.com/samples/XlsIO.Web/4.4.0.51/60326/main.htm

Kindly let me know if you have any other questions.

Thanks,
Melba