how to export excel and freeze panes in second row using asp

Hi, here is an alternative approach with this excel's dll for .net.

// Load excel file.
var excel = ExcelFile.Load(Server.MapPath("~/Book1.xlsx"));
// Get active sheet.
var sheet = excel.Worksheets.ActiveWorksheet;
// Freeze second sheet's row.
sheet.Panes = new WorksheetPanes(PanesState.Frozen, 0, 2, "A3", PanePosition.BottomLeft);

Now regarding the export, I'm not exactly sure what your requirement is here, nevertheless here is how you can export excel's data to a DataTable and here is how you can export excel file to ASP.NET's client:

// Export excel's data to DataTable
DataTable table = sheet.CreateDataTable(new CreateDataTableOptions());
 
// Export excel file to client's browser.
excel.Save(this.Response, "Book1.xlsx");

Hello KRayudu,
<1>here is the demo for freeze panes in the second row:

using Spire.Xls;
using System.Drawing;

namespace FreezePane
{
class Program
{
static void Main(string[] args)
{
 //Load File
 Workbook workbook = new Workbook();
 workbook.LoadFromFile

 (@"E:\Work\Documents\ExcelFiles\PartSalesInfo.xlsx");
 Worksheet sheet = workbook.Worksheets[0];

 //Freeze the Second Row
 sheet.FreezePanes(3, 1);

 //Save and Launch
 workbook.SaveToFile("FreezePane.xlsx", ExcelVersion.Version2010);
 System.Diagnostics.Process.Start(workbook.FileName);
}
}
}
download spire.xls from here:
http://spreadsheet.codeplex.com/
<2>how to export excel?
do you mean export from datatable(database) to excel? if so
Demo here:

//export datatable to excel
Workbook book = new Workbook();
Worksheet sheet = book.Worksheets[0];
sheet.InsertDataTable(t, true, 1, 1);
book.SaveToFile("insertTableToExcel.xls");

for detailed info here:
http://www.e-iceblue.com/Knowledgebase/Spire.XLS/Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html
Also dataset to excel:
http://www.c-sharpcorner.com/uploadfile/babu_2082/export-dataset-to-excel/default.aspx