Hi All,
I am using following sub procedure to export data to Excel in Asp.net
But i am getting error when excel exceeds its limit(65536).
How can i convert it to sheet wise when it reaches maximum limit.
Here is code:
Public
Sub ExportToExcel()'#Region "Export Grid to Excel"
dTAll = Session(
dt = dTAll.Copy()
"dTAll")Dim dt Go to the complete details ...