How to display false condition for my code

This program is looking for "p" in 10th column of Excel Sheet. If "p" is found, then required information is extracted and sent to the desired email id. What to do if "p" is not present in the worksheet? It should display message that "p" is not present in the worksheet. How to do this?

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.IO;
using System.Runtime.Interolservices;
using System.Data;
using Excel = Microsoft.Office.Interop.Excel;
using Outlook = Microsoft.Office.Interop.Outlook;
namespace ExcelFile
{
class Stu
{
static void Main(string[] args)
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
Excel.Range range;
int rCnt;
int row = 0;
int col = 0;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(@"F:\\Date_Plan.xlsm", 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets["Main Page"];
range = xlWorkSheet.UsedRange;
row = range.Rows.Count;
col = range.Columns.Count;
List lst = new List();
for (rCnt = 1; rCnt < row; rCnt++)
{
if ((range.Cells[rCnt, 10] as Excel.Range).Value2 != null)
{
if((range.Cells[rCnt, 10] as Excel.Range).Value2.ToString() == "p")
{
lst ls = new lst();
ls.lstName = gettingvalue((range.Cells[rCnt, 1] as Excel.Range));
ls.lstUSN = gettingvalue((range.Cells[rCnt, 2] as Excel.Range));
ls.DOB = gettingvalue((range.Cells[rCnt, 3] as Excel.Range));
ls.Education = gettingvalue((range.Cells[rCnt, 4] as Excel.Range));
ls.Others = gettingvalue((range.Cells[rCnt, 5] as Excel.Range));
lst.Add(ls);
}
}
}
try
{
Outlook.Application oApp = new Outlook.Application();
Outlook.MailItem oMsg = (Outlook.MailItem)oApp.CreateItem(Outlook.OlItemType.olMailItem);
var sb = new StringBuilder();
sb.AppendLine("");
sb.AppendLine("");
                    sb.AppendLine("");
                    sb.AppendLine("
");
                    sb.AppendLine("
");
                    sb.AppendLine("
");
                    sb.AppendLine("
");
                    sb.AppendLine("
");
                    sb.AppendLine("
");
                    sb.AppendLine("
");

                    foreach (var row in lst)
                    {
                        sb.AppendLine("
");
                        sb.AppendLine("
");
                        sb.AppendLine("
");
                        sb.AppendLine("
");
                        sb.AppendLine("
");
                        sb.AppendLine("
");
                        sb.AppendLine("
");
                    }
                    sb.AppendLine("
lst Name lst USN DOB Education Others
" + row.lstName + " " + row.lstUSN + " " + row.DOB + " " + row.Education + " " + row.Others + "
");
sb.AppendLine("");
oMsg.HTMLBody = sb.ToString();
oMsg.Subject = "List of all std ";
Outlook.Recipients oRecils = (Outlook.Recipients)oMsg.Recipients;
Outlook.Recipient oRecip = (Outlook.Recipient)oRecils.Add("[email protected]");
oRecip.Resolve();
oMsg.Send();
oRecip = null;
oRecils = null;
oMsg = null;
oApp = null;
}
catch (Exception ex)
{
}
xlWorkBook.colose(true, null, null);
xlApp.Quit();
Marshal.ReleaseComObject(xlWorkSheet);
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
}
private static string gettingvalue(Microsoft.Office.Interop.Excel.Range range)
{
if (range.Value2 != null)
{
return range.Value2.ToString();
}
else
return null;
}
}
}
public class lst
{
public string lstName { get; set; }
public string lstUSN { get; set; }
public string DOB { get; set; }
public string Education { get; set; }
public string Others { get; set; }
}

lst Name	lst USN	DOB	Education	Others
" + row.lstName + "	" + row.lstUSN + "	" + row.DOB + "	" + row.Education + "	" + row.Others + "

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Karthi Keyan9y ago
Hi Raj,

I can't find where you are checking the 'p' value in your code. my suggesstion is bind your excel data to the DataTable. Then Check Each row of the DataTable to contain p value or not. that is easy for you.