//private void DataGrid_LoadingRow_(object sender, DataGridRowEventArgs e) //{ // e.Row.Header = (e.Row.GetIndex() + 1).ToString(); //} private void ViewModelChanged(object sender, DependencyPropertyChangedEventArgs e) { this.viewModel_ = this.DataContext as OptionGreekPositionViewModel_1928; this.bindingPanel_.DataContext = this.viewModel_.GBMParaViewModel_; this.OPTION_POSITIONDataGrid_.ItemsSource = this.viewModel_.OptionViewModelList_; }
private void GreekPosition1928_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]; OptionGreekPositionViewModel_1928 ogpvm = new OptionGreekPositionViewModel_1928(); ogpvm.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 = "1928 자기선물옵션 펀드별 위험현황"; //w.Width = 800; w.Height = 610; w.Content = ogpvm.view(); w.Visibility = Visibility.Visible; w.ShowDialog(); } catch (Exception) { } }