コード例 #1
0
 // Writing Quote Results to Excel
 public void SaveToExcel(int x, int y, string dataToSend, int sheetNum)
 {
     excel.Application Xapp      = new excel.Application();
     excel.Workbook    xWorkbook = Xapp.Workbooks.Open(ExcelFileLocationWork);
     try
     {
         excel.Worksheet xWorksheet = xWorkbook.Sheets[sheetNum];
         excel.Range     xRange     = xWorksheet.UsedRange;
         xRange.Cells[x, y] = dataToSend;
         xWorkbook.Save();
     }
     finally
     {
         xWorkbook.Close(true);
         Xapp.Quit();
         System.Runtime.InteropServices.Marshal.ReleaseComObject(Xapp);
     }
 }
コード例 #2
0
 // Lookup values from Excel Workbook to use as data in Automation
 public string ExcelLookup(int x, int y, int sheetNum)
 {
     excel.Application Xapp      = new excel.Application();
     excel.Workbook    xWorkbook = Xapp.Workbooks.Open(ExcelFileLocationWork);
     try
     {
         excel.Worksheet xWorksheet = xWorkbook.Sheets[sheetNum];
         excel.Range     xRange     = xWorksheet.UsedRange;
         return(xRange.Cells[x][y].Value.ToString());
     } catch (RuntimeBinderException)
     {
         string emptyValue = "Empty/Invalid Value: Check your selected data set!";
         System.Diagnostics.Debug.WriteLine("Null value found, check Excel values");
         Console.Write("Null value found, check Excel values");
         return(emptyValue);
     }
     // Release Excel & Quit (Prevents Excel processes from ramping up)
     finally
     {
         xWorkbook.Close(true);
         Xapp.Quit();
         System.Runtime.InteropServices.Marshal.ReleaseComObject(Xapp);
     }
 }