Exporting data from database to excel sheet without use of gridview

i want that when i click a button the data from particular table(including table header) should import to excel sheet and excel should save on solution explore folder excel.
i dont want to use any data grid like grid view or any thing.
how i can achieve this