private void btnOK_Click(object sender, RoutedEventArgs e)
 {
     result = GoogleHistoryManager.GoogleHistory(this.tbSecurityId.Text, DateTime.Parse(this.tbStartDate.Text), DateTime.Parse(this.tbEndDate.Text));
     if (ExcelHandler.WriteToRangeHandler != null)
     {
         ExcelHandler.WriteToRangeHandler(result);
     }
 }
예제 #2
0
 private void button_Click(object sender, RoutedEventArgs e)
 {
     this.Close();
     if (ExcelHandler.WriteToRangeHandler != null)
     {
         ExcelHandler.WriteToRangeHandler(this.result, this.History);
     }
 }
예제 #3
0
 private void postToExcel()
 {
     if (result.Count > 0)
     {
         if (result.ContainsKey("test1"))
         {
             string[,] response = result["test1"];
             //dynamic xlApp = ExcelDnaUtil.Application;
             //dynamic sheet2 = xlApp.ActiveWorkbook.WorkSheets("Sheet2");
             //dynamic newSheet = xlApp.ActiveWorkbook.Worksheets.Add(After: sheet2);
             //dynamic range = newSheet.Range("A1:B" + (response.GetUpperBound(0) + 1).ToString());
             //range.Value = response;
             //ExcelOperator.ReadWriteRange.WriteToRange(response);
             if (ExcelHandler.WriteToRangeHandler != null)
             {
                 ExcelHandler.WriteToRangeHandler(response);
             }
         }
         result.Remove("test1");
     }
 }