
File check
By: a guest on
Aug 10th, 2012 | syntax:
C# | size: 2.24 KB | hits: 19 | expires: Never
private void bCheck_Click(object sender, EventArgs e)
{
foreach (int indexChecked in clbLog.CheckedIndices)
{
int index2;
index2 = indexChecked + 1;
Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkbook;
Microsoft.Office.Interop.Excel.Worksheet xlWorksheet;
Microsoft.Office.Interop.Excel.Range range;
string str1;
string str2;
xlApp = new Microsoft.Office.Interop.Excel.Application();
xlWorkbook = xlApp.Workbooks.Open(ofdInputFile.FileName, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", true, false, 0, true, 1, 0);
xlWorksheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkbook.Worksheets.get_Item(1);
range = xlWorksheet.UsedRange;
str1 = (string)(range.Cells[index2, 1] as Microsoft.Office.Interop.Excel.Range).Value2;
str2 = (string)(range.Cells[index2, 2] as Microsoft.Office.Interop.Excel.Range).Value2;
System.Net.WebRequest request = System.Net.WebRequest.Create(str2);
request.Method = "Head";
System.Net.HttpWebResponse response = (System.Net.HttpWebResponse)request.GetResponse();
string online = " ONLINE!";
string offline = " OFFLINE!";
if (response.StatusDescription == "OK")
{
clbLog.ForeColor = Color.Green;
clbLog.Items.RemoveAt(indexChecked);
clbLog.Items.Insert(indexChecked, str1 + online);
}
else
{
clbLog.ForeColor = Color.Red;
clbLog.Items.RemoveAt(indexChecked);
clbLog.Items.Insert(indexChecked, str1 + offline);
}
xlWorkbook.Close(true, null, null);
xlApp.Quit();
releaseObject(xlWorksheet);
releaseObject(xlWorkbook);
releaseObject(xlApp);
}
}