private void PreCalcExcel()
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(vari.DefaultDirectory + vari.MicaTemplateName, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
xlApp.DisplayAlerts = false;
//MessageBox.Show(xlWorkSheet.get_Range("B3").Value.ToString());
//WRITE DATA TO EXCEL SHEET
xlWorkSheet.Cells[3, 3] = myComboBox.Text;
xlWorkSheet.Cells[4, 3] = tbQty1.Text;
xlWorkSheet.Cells[5, 3] = tbQty2.Text;
xlWorkSheet.Cells[6, 3] = tbQty3.Text;
xlWorkSheet.Cells[7, 3] = tbQty4.Text;
xlWorkSheet.Cells[9, 3] = tbSeg.Text;
xlWorkSheet.Cells[10, 3] = cmbLockup.Text;
xlWorkSheet.Cells[11, 3] = tbDia.Text;
xlWorkSheet.Cells[12, 3] = tbWidth.Text;
xlWorkSheet.Cells[13, 3] = cmbTermStyle.Text;
xlWorkSheet.Cells[14, 3] = tbLeads.Text;
xlWorkSheet.Cells[15, 3] = tbLeadCov.Text;
xlWorkSheet.Cells[16, 3] = tbWatts.Text;
xlWorkSheet.Cells[17, 3] = tbVolts.Text;
xlWorkSheet.Cells[19, 3] = tbHoles.Text;
xlWorkSheet.Cells[20, 3] = tbCutouts.Text;
xlWorkSheet.Cells[21, 3] = cmbTermLoc.Text;
xlWorkSheet.Cells[22, 3] = tbTermMeasure.Text;
xlWorkSheet.Cells[23, 3] = tbMulti.Text;
xlWorkSheet.Cells[20, 6] = tbSpecials.Text;
xlWorkSheet.Cells[3, 13] = tbSMT.Text;
xlWorkSheet.Cells[3, 4] = lMulti.Text;
xlWorkSheet.Cells[7, 13] = tbManualAdder.Text;
databindings.q1 A = new databindings.q1();
{ A.lq1 = string.Format("{0:C}", Convert.ToDecimal(xlWorkSheet.get_Range("F4").Value)); }
this.lq1.DataContext = A;
vari.p1 = xlWorkSheet.get_Range("F4").Value;
databindings.q2 B = new databindings.q2();
{ B.lq2 = string.Format("{0:C}", Convert.ToDecimal(xlWorkSheet.get_Range("F5").Value)); }
this.lq2.DataContext = B;
vari.p2 = xlWorkSheet.get_Range("F5").Value;
databindings.q3 C = new databindings.q3();
{ C.lq3 = string.Format("{0:C}", Convert.ToDecimal(xlWorkSheet.get_Range("F6").Value)); }
this.lq3.DataContext = C;
vari.p3 = xlWorkSheet.get_Range("F6").Value;
databindings.q4 D = new databindings.q4();
{ D.lq4 = string.Format("{0:C}", Convert.ToDecimal(xlWorkSheet.get_Range("F7").Value)); }
this.lq4.DataContext = D;
vari.p4 = xlWorkSheet.get_Range("F7").Value;
databindings.PN E = new databindings.PN();
{ E.lPN = string.Format("{0:C}", xlWorkSheet.get_Range("C1").Value); }
this.lPN.DataContext = E;
vari.pn = xlWorkSheet.get_Range("C1").Text;
vari.desc = xlWorkSheet.get_Range("B26").Text;
xlWorkBook.SaveAs(vari.TempDir + vari.MicaTemplateName);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
AddersCalc2();
}
private void PreCalcExcel()
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(vari.DefaultDirectory + vari.CartTemplateName, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
xlApp.DisplayAlerts = false;
//WRITE DATA TO EXCEL SHEET
xlWorkSheet.Cells[3, 4] = myComboBox.Text;
xlWorkSheet.Cells[3, 7] = lMulti.Text;
xlWorkSheet.Cells[4, 4] = tbQty1.Text;
xlWorkSheet.Cells[5, 4] = tbQty2.Text;
xlWorkSheet.Cells[6, 4] = tbQty3.Text;
xlWorkSheet.Cells[7, 4] = tbQty4.Text;
xlWorkSheet.Cells[8, 4] = cmbDiameter.Text;
xlWorkSheet.Cells[9, 4] = tbLength.Text;
xlWorkSheet.Cells[10, 4] = cmbTermStyle.Text;
xlWorkSheet.Cells[11, 4] = tbLeads.Text;
xlWorkSheet.Cells[12, 4] = tbLeadCov.Text;
xlWorkSheet.Cells[13, 4] = tbWatts.Text;
xlWorkSheet.Cells[14, 4] = tbVolts.Text;
xlWorkSheet.Cells[16, 4] = tbLabor.Text;
xlWorkSheet.Cells[9, 15] = tbManualAdder.Text;
xlWorkSheet.Cells[18, 4] = tbSpecials.Text;
xlWorkSheet.Cells[3, 15] = tbSMT.Text;
databindings.q1 A = new databindings.q1();
{ A.lq1 = string.Format("{0:C}", Convert.ToDecimal(xlWorkSheet.get_Range("G4").Value)); }
this.lq1.DataContext = A;
vari.p1 = xlWorkSheet.get_Range("G4").Value;
databindings.q2 B = new databindings.q2();
{ B.lq2 = string.Format("{0:C}", Convert.ToDecimal(xlWorkSheet.get_Range("G5").Value)); }
this.lq2.DataContext = B;
vari.p2 = xlWorkSheet.get_Range("G5").Value;
databindings.q3 C = new databindings.q3();
{ C.lq3 = string.Format("{0:C}", Convert.ToDecimal(xlWorkSheet.get_Range("G6").Value)); }
this.lq3.DataContext = C;
vari.p3 = xlWorkSheet.get_Range("G6").Value;
databindings.q4 D = new databindings.q4();
{ D.lq4 = string.Format("{0:C}", Convert.ToDecimal(xlWorkSheet.get_Range("G7").Value)); }
this.lq4.DataContext = D;
vari.p4 = xlWorkSheet.get_Range("G7").Value;
databindings.PN E = new databindings.PN();
{ E.lPN = string.Format("{0:C}", xlWorkSheet.get_Range("D1").Value); }
this.lPN.DataContext = E;
vari.pn = xlWorkSheet.get_Range("D1").Text;
xlWorkBook.SaveAs(vari.TempDir + vari.CartTemplateName);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
AddersCalc2();
}