How freeze first row in excel by using EPPlus.dll ???

[Dharmesh S Patil]

How can i use freeze Pane for first row in excel by vb.net using EPPlus.dll for excel.

[Richard Deeming]

From the ExcelWorksheet object, access the View property. On the returned ExcelWorksheetView object, call the FreezePanes(row, column) method, passing in the row and column of the first cell which is not frozen. For example, to freeze the first row, you would need to pass in 2 to the row parameter:

sheet.View.FreezePanes(2, 1)

One of the samples on the site demonstrates this: https://epplus.codeplex.com/SourceControl/latest#SampleApp/Sample6.cs[^]

---

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

[Dharmesh S Patil]

Thanks it's work :)