public static void SaveXLS(string filename, ViewModel.MainWindow data) { Uri uri = new Uri("/Resources/hetvegekezelo.xlsm", UriKind.Relative); using (var stream = System.Windows.Application.GetResourceStream(uri).Stream) using (var f = File.Create(filename)) { stream.CopyTo(f); } var excel = new Microsoft.Office.Interop.Excel.Application { Visible = true }; Workbook file = excel.Workbooks.Open(filename); try { Worksheet sheet = file.Worksheets[0]; Range c = sheet.Cells; int i = 2; foreach (Person p in data.Students) { c[i, 1].Activate(); string[] nev = p.Name.Split(new char[] { ' ' }, 2); c[i, 1] = nev[0]; c[i, 2] = nev[1]; i++; } } finally { file.Save(); } }
public Algorithms(ViewModel.MainWindow data, object _lock) { this._lock = _lock; d = data; Beosztando = d.Groups.ToList(); foreach (var schedule in d.Schedule) { BindingOperations.EnableCollectionSynchronization(schedule, _lock); } }