Example #1
0
        /// <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!");
        }