//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);
}
