Create Excel Sheet

Question

Hi All...Expert I am using .aspx page .I am sending all record client mail.but i want that all record convert excel sheet(runtime) and send mail this excel sheet Please give an example....

Jiteendra Sampathirao · Answer

hi openXMl is also one solution....you can find the solution by jusy googling..

krishna swami · Answer

please write code ....it's possible to u.

Jiteendra Sampathirao · Answer

hi then use Interop services.... Refer Nice LINK but some times interop services creates the problem when we are deploying the application....(permission level errors) and this is not an easy approach...

krishna swami · Answer

i want not use grid view...i want that all record add excel sheet automatically.and send mail to client with excel sheet(which create runtime).

Jiteendra Sampathirao · Answer

HI go through this link for export gridview data to Excel Click for sending mail with attachments... Refer

Mahesh Chand · Answer

There are 3 ways to do this. 1. Use office interoperability. You must have office on the server for this. 2. VSTO 3. Build a dynamic DataGrid fill data n export to excel. Easiest method. Search this site for export to excel etc.