/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnExport_Click(object sender, EventArgs e) { string filename = string.Empty; FileDialog saver = new SaveFileDialog(); saver.Filter = "(*.xls)|*.xls"; if (saver.ShowDialog() == DialogResult.OK) { filename = saver.FileName; Utility.getResource(filename, "Template.xls"); } else { return; } List <HiringTracking> export = GetTarget(); dynamic excelObj = Interaction.CreateObject("Excel.Application"); excelObj.Visible = true; dynamic workbook; workbook = excelObj.Workbooks.Open(filename); HiringTracking.ExportData(workbook, export); workbook.Close(); excelObj.Quit(); excelObj = null; MessageBox.Show("Export Complete!"); }