string dailyFile = "DeliveryChallan(" + date + time + ").xls"; File.Copy(Application.StartupPath + "\\DCTemplate.xls", Application.StartupPath + dailyFile); Microsoft.Office.Interop.Excel.Application xlApp; Microsoft.Office.Interop.Excel.Workbook xlWorkBook; Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; xlApp = new Excel.ApplicationClass(); xlWorkBook = App.Workbooks.Open(Application.StartupPath + dailyFile, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkBook.Save(); xlApp.Workbooks.Close(); xlApp.Quit();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)