private void ViewModelChanged(object sender, DependencyPropertyChangedEventArgs e) { this.viewModel_ = this.DataContext as OptionManagerViewModel; this.bindingPanel_.DataContext = this.viewModel_.GBMParaViewModel_; this.OPTION_POSITIONCallDataGrid_.ItemsSource = this.viewModel_.CallOptionViewModelList_; this.OPTION_POSITIONPutDataGrid_.ItemsSource = this.viewModel_.PutOptionViewModelList_; }
private void VanillaOptionBtn_Click(object sender, RibbonControlEventArgs e) { try { Excel.Worksheet activeWorksheet = ((Excel.Worksheet)Globals.ThisAddIn.Application.ActiveSheet); //object cellValue = activeWorksheet.get_Range("A1", System.Type.Missing).Value2; //activeWorksheet.get_Range("A1", System.Type.Missing).Value2 = "My new value"; //Excel.Range range1 = activeWorksheet.get_Range("A1", "B2"); //object[,] s = (object[,])range1.Value2; //Excel.Range range2 = activeWorksheet.get_Range("A3", "B4"); //range2.Value2 = (string)s[1, 2]; OptionManagerViewModel omvm = new OptionManagerViewModel(); omvm.loadDataFromExcelSheet(activeWorksheet); MetroWindow w = new MetroWindow(); ResourceDictionary merge = new ResourceDictionary(); ResourceDictionary rd1 = new ResourceDictionary(); rd1.Source = new Uri("pack://application:,,,/MahApps.Metro;component/Styles/Controls.xaml"); merge.MergedDictionaries.Add(rd1); ResourceDictionary rd2 = new ResourceDictionary(); rd2.Source = new Uri("pack://application:,,,/MahApps.Metro;component/Styles/Fonts.xaml"); merge.MergedDictionaries.Add(rd2); ResourceDictionary rd3 = new ResourceDictionary(); rd3.Source = new Uri("pack://application:,,,/MahApps.Metro;component/Styles/Colors.xaml"); merge.MergedDictionaries.Add(rd3); ResourceDictionary rd4 = new ResourceDictionary(); rd4.Source = new Uri("pack://application:,,,/MahApps.Metro;component/Styles/Accents/Steel.xaml"); merge.MergedDictionaries.Add(rd4); ResourceDictionary rd5 = new ResourceDictionary(); rd5.Source = new Uri("pack://application:,,,/MahApps.Metro;component/Styles/Accents/BaseLight.xaml"); merge.MergedDictionaries.Add(rd5); w.Resources = merge; w.Title = "8586 지수옵션 민감도 비교"; //w.Width = 800; w.Height = 560; w.Content = omvm.view(); w.Visibility = Visibility.Visible; w.Show(); } catch (Exception) { } }