Mailing Excel worksheet as an attachment without saving C#

Question

Hi ALL,

I am creating an Excel worksheet dynamically in C# codebehind and i want that Excel worksheet to send as an email as an attachment. I dont want to save the worksheet. Currently am saving the worksheet, then attaching the saved worksheet, then send email, then delete the saved worksheet.

But i want to create dynamically Excel worksheet and then attach that worksheet without saving.

Is there any solution to this.

Thanks in Advance

Vishwas

Answer 1

Hi Monika,


Pragma automatic_index command is by deafult true in Sqlite.

so when you  used Pragma automatic_index=true, its mean indexing will be continue


to stop default indexing use 

sqlite> Pragma automatic_index=false.