//Reading Text file and Writing into Text file private void WriteTextFile(string sruninFileName, Comments ocmnts, Description odesc, Titles otitles, VariableNames ovnames, VariableInfo ovinfo) { try { string sSOAPPTextFilePath = Application.StartupPath + "\\bin\\" + "Standard_Header_SOAPP.runin"; string sFilePath = Utility.m_sOutputFolderPath; string sNewTextFilePath = sFilePath + "" + sruninFileName + ".runin"; if (System.IO.File.Exists(sSOAPPTextFilePath)) { System.IO.File.Copy(sSOAPPTextFilePath, sNewTextFilePath, true); using (StreamWriter sw = File.AppendText(sNewTextFilePath)) { //Writing Comments of Column (A1-A6) for (int i = 0; i != ocmnts.lstCmnts.Count; i++) { sw.WriteLine("$CMT " + ocmnts.lstCmnts[i].m_sCellA1_AEnd.Trim()); } sw.WriteLine(" "); //Writing Plane Description of column (H2-H10) and (I2-I10) sw.WriteLine("$CMT Ariplane, Rating, Model and Inlet Recovery"); sw.WriteLine("$SET"); for (int i = 0; i != odesc.lstDesc.Count; i++) { sw.WriteLine(" " + odesc.lstDesc[i].m_sCellH2_HEnd.Trim() + " = " + odesc.lstDesc[i].m_sCellI2_IEnd.Trim() + ".,"); } sw.WriteLine("$END"); sw.WriteLine(" "); for (int i = 0; i != otitles.lstTitles.Count; i++) { sw.WriteLine("$SET CMNT=1., $END"); //Writing Titles of columns(A13-End), (B13-End)) sw.WriteLine(otitles.lstTitles[i].m_sValueA13_AEnd.Trim() + " - " + otitles.lstTitles[i].m_sValueB13_BEnd.Trim()); //Writing variable Information of columns C13-Q13) and with variable names of row (C12-Q12) sw.WriteLine("$RUN"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sC12.Trim() + " = " + ovinfo.lstVInfo[i].m_sALT.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sD12.Trim() + " = " + ovinfo.lstVInfo[i].m_sXM.Trim() + ","); sw.WriteLine(" " + ovnames.lstVNames[0].m_sE12.Trim() + " = " + ovinfo.lstVInfo[i].m_sSEGTIMES.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sF12.Trim() + " = " + ovinfo.lstVInfo[i].m_sSEGTIMEM.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sG12.Trim() + " = " + ovinfo.lstVInfo[i].m_sCMLTIMEM.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sH12.Trim() + " = " + ovinfo.lstVInfo[i].m_sFLAG.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sI12.Trim() + " = " + ovinfo.lstVInfo[i].m_sDTAMB.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sJ12.Trim() + " = " + ovinfo.lstVInfo[i].m_sHUMD.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sK12.Trim() + " = " + ovinfo.lstVInfo[i].m_sGHPX.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sL12.Trim() + " = " + ovinfo.lstVInfo[i].m_sSWB2X.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sM12.Trim() + " = " + ovinfo.lstVInfo[i].m_sSWB3X.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sN12.Trim() + " = " + ovinfo.lstVInfo[i].m_sSWB14X.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sO12.Trim() + " = " + ovinfo.lstVInfo[i].m_sRC.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sP12.Trim() + " = " + ovinfo.lstVInfo[i].m_sSPARM.Trim() + ".,"); sw.WriteLine(" " + ovnames.lstVNames[0].m_sQ12.Trim() + " = " + ovinfo.lstVInfo[i].m_sPARM.Trim() + ".,"); sw.WriteLine("$END"); sw.WriteLine(" "); } lbStatus.Visible = false; } } else { MessageBox.Show("There is no file in given path " + sSOAPPTextFilePath); } } catch (Exception ee) { Utility.WriteErrorLog(ee); } }
//Reading an Excel file private string ReadExcelFile() { string sruninFileName = ""; try { Comments ocmnts = new Comments(); Description odesc = new Description(); Titles otitles = new Titles(); VariableNames ovnames = new VariableNames(); VariableInfo ovinfo = new VariableInfo(); //Creating COM Objects Excel.Application xlApp = new Excel.Application(); xlApp.Visible = false; xlApp.DisplayAlerts = false; Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(tbInputFile.Text.Trim(), Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); Excel.Worksheet xlWorksheet = xlWorkbook.Worksheets[2]; int range = xlWorksheet.UsedRange.Rows.Count; //Reading Comments of rows(A1-A6) for (int rw = 1; rw <= 6; rw++) { Comments oCmnts = new Comments(); oCmnts.m_sCellA1_AEnd = GetCellValue(xlWorksheet, rw, 1); if (oCmnts.m_sCellA1_AEnd.Length == 0) { break; } ocmnts.lstCmnts.Add(oCmnts); } //Reading Description of rows(H2-H10) and rows(I2-I10) for (int nRw = 2; nRw <= 10; nRw++) { Description oDesc = new Description(); oDesc.m_sCellH2_HEnd = GetCellValue(xlWorksheet, nRw, 8); oDesc.m_sCellI2_IEnd = GetCellValue(xlWorksheet, nRw, 9); if (oDesc.m_sCellH2_HEnd.Length == 0 || oDesc.m_sCellI2_IEnd.Length == 0) { break; } odesc.lstDesc.Add(oDesc); } //Reading Titles of rows (A13 to AEnd) and (B13 to BEnd) for (int r = 13; r <= range; r++) { Titles oTitles = new Titles(); oTitles.m_sValueA13_AEnd = GetCellValue(xlWorksheet, r, 1); oTitles.m_sValueB13_BEnd = GetCellValue(xlWorksheet, r, 2); if (oTitles.m_sValueA13_AEnd.Length == 0) { break; } otitles.lstTitles.Add(oTitles); } //Reading Variable names of columns (C12-Q12) VariableNames oVNames = new VariableNames(); oVNames.m_sC12 = GetCellValue(xlWorksheet, 12, 3); oVNames.m_sD12 = GetCellValue(xlWorksheet, 12, 4); oVNames.m_sE12 = GetCellValue(xlWorksheet, 12, 5); oVNames.m_sF12 = GetCellValue(xlWorksheet, 12, 6); oVNames.m_sG12 = GetCellValue(xlWorksheet, 12, 7); oVNames.m_sH12 = GetCellValue(xlWorksheet, 12, 8); oVNames.m_sI12 = GetCellValue(xlWorksheet, 12, 9); oVNames.m_sJ12 = GetCellValue(xlWorksheet, 12, 10); oVNames.m_sK12 = GetCellValue(xlWorksheet, 12, 11); oVNames.m_sL12 = GetCellValue(xlWorksheet, 12, 12); oVNames.m_sM12 = GetCellValue(xlWorksheet, 12, 13); oVNames.m_sN12 = GetCellValue(xlWorksheet, 12, 14); oVNames.m_sO12 = GetCellValue(xlWorksheet, 12, 15); oVNames.m_sP12 = GetCellValue(xlWorksheet, 12, 16); oVNames.m_sQ12 = GetCellValue(xlWorksheet, 12, 17); ovnames.lstVNames.Add(oVNames); lbStatus.Text = "Writing into text file..."; //Reading VariableInfo of Columns(C12-Q12) till end of rows for (int r = 13; r <= range; r++) { VariableInfo oVInfo = new VariableInfo(); oVInfo.m_sALT = GetCellValue(xlWorksheet, r, 3); oVInfo.m_sXM = GetCellValue(xlWorksheet, r, 4); oVInfo.m_sSEGTIMES = GetCellValue(xlWorksheet, r, 5); oVInfo.m_sSEGTIMEM = GetCellValue(xlWorksheet, r, 6); oVInfo.m_sCMLTIMEM = GetCellValue(xlWorksheet, r, 7); oVInfo.m_sFLAG = GetCellValue(xlWorksheet, r, 8); oVInfo.m_sDTAMB = GetCellValue(xlWorksheet, r, 9); oVInfo.m_sHUMD = GetCellValue(xlWorksheet, r, 10); oVInfo.m_sGHPX = GetCellValue(xlWorksheet, r, 11); oVInfo.m_sSWB2X = GetCellValue(xlWorksheet, r, 12); oVInfo.m_sSWB3X = GetCellValue(xlWorksheet, r, 13); oVInfo.m_sSWB14X = GetCellValue(xlWorksheet, r, 14); oVInfo.m_sRC = GetCellValue(xlWorksheet, r, 15); oVInfo.m_sSPARM = GetCellValue(xlWorksheet, r, 16); oVInfo.m_sPARM = GetCellValue(xlWorksheet, r, 17); if (oVInfo.m_sALT.Length == 0) { break; } ovinfo.lstVInfo.Add(oVInfo); } //Reading Text File Name if (xlWorksheet.get_Range("I1", "I1").Value2 != null) { sruninFileName = xlWorksheet.get_Range("I1", "I1").Value2; } //close excel xlWorkbook.Close(false, Type.Missing, Type.Missing); Marshal.ReleaseComObject(xlWorksheet); Marshal.ReleaseComObject(xlWorkbook); xlApp.Quit(); Marshal.ReleaseComObject(xlApp); //Wrire the text file-- if (sruninFileName.Length > 0) { WriteTextFile(sruninFileName, ocmnts, odesc, otitles, ovnames, ovinfo); } else { Utility.WarnUser("In Excell sheet, Cell I1 doesn't have any value"); } } catch (Exception ee) { Utility.WriteErrorLog(ee); } return(sruninFileName); }