Question: how to export gridview data to excel with formatting asp net?
Answer: Go to the SQL Database side. Create an Employee Information table. create table EmployeeDB. ( EmpID int primary key identity(1,1), ... 
Go to the Visual Studio side as in the following. Now go to your project design (. aspx) page. Add a page using Master page. Provide a specific name for the page and click the Add button.