Comments by Sperihat (Top 2 by date)

Sperihat 13-Apr-16 6:18am View

As yusu mentioned you can use word automation in C# to this or you could try this word's library for C#. For example see this sample on how you can edit a word document from a C# code.

Sperihat 13-Apr-16 5:56am View

Here is a lot simpler approach how you can export a DataSet into an Excel file:

var ef = new ExcelFile();

foreach (DataTable table in Report.Tables)
ef.Worksheets.Add(table.TableName).InsertDataTable(table);

ef.Save(FileName);

The code uses this excel's library for C#.
Regarding the predefined excel, instead of using "new ExcelFile()" you should then use "ExcelFile.Load(path to your template workbook)".
Also note that you don't actually need to save your file on disk, you could save it into a stream and then attach that file's stream to your email, for example:

var options = new XlsSaveOptions();
var stream = new MemoryStream();
ef.Save(stream, options);

// ...

emailMessage.Attachments.Add(
new Attachment(options.ContentType, stream));

Note I'm using this email's library for C# to send an email with the attachment (you can find full sample here).