static void SplitAndMail(string FileName) { Microsoft.Office.Interop.Excel.Application xlApp; xlApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook xlWorkBook; FileInfo fi = new FileInfo(FileName); string FullFileName = fi.FullName.ToString(); try { xlWorkBook = xlApp.Workbooks.Open(FullFileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); } catch { Console.WriteLine("You must choose a file"); return; } xlWorkBook = xlApp.Workbooks.Open(FullFileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); Microsoft.Office.Interop.Excel.Range rng = xlApp.get_Range("A1"); //int index = 0; string liteFileName = FileName.Replace(".xlsx", ""); foreach (Microsoft.Office.Interop.Excel.Worksheet displayWorksheet in xlApp.Worksheets) { string root = fi.Directory.ToString(); string sheetName = displayWorksheet.Name.ToString(); string SaveFileName = root + "\\" + liteFileName + "." + sheetName + ".xlsx"; //Microsoft.Office.Interop.Excel.Application NewxlApp; //NewxlApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook NewWorkbook; NewWorkbook = xlApp.Workbooks.Add(); Microsoft.Office.Interop.Excel.Worksheet NewWorkSheet; NewWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)NewWorkbook.Worksheets.Add(); displayWorksheet.Copy(NewWorkSheet); NewWorkbook.SaveAs(SaveFileName); NewWorkbook.Save(); NewWorkbook.Close(); } }
internal void OnNewWorkbook(object wb) { NewWorkbook?.Invoke(GetWorkbook(wb)); }