I made a code to enter two inputs to the website and search to get into the new page of two tables(the html code is as below)
<html><head>
<title>IEC</title><style type="text/css"></style></head>
<body>
<form action="" method="GET">
<h2 align="CENTER">Importer Exporter Code</h2>
</form>
<table border="0">
<tbody><tr><th valign="TOP" align="LEFT" colspan="50"></th><th valign="TOP" align="LEFT" colspan="3"></th><th valign="TOP" align="LEFT" colspan="50"></th></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">IEC</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">0411021117</td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">IEC Allotment Date</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">15.09.2011</td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">File Number</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">04/08/130/02067/AM12/ </td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">File Date</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">14.09.2011</td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">IEC</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">0411021117</td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">Party Name and Address</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">KAMADHENU EXPORTS <br>NO. 638, LIG-1, MMDA <br>MATHUR, <br>CHENNAI <br>PIN-600068<br></td></tr>
I have to extract the text(highlightedbyme) which is in the 7th row of the first table. As here , there is no table name or id. please, provide me a code or idea of how to get the data and store it into one excel cell.
I'm a starter in this coding.
Tanks in advance.
<html><head>
<title>IEC</title><style type="text/css"></style></head>
<body>
<form action="" method="GET">
<h2 align="CENTER">Importer Exporter Code</h2>
</form>
<table border="0">
<tbody><tr><th valign="TOP" align="LEFT" colspan="50"></th><th valign="TOP" align="LEFT" colspan="3"></th><th valign="TOP" align="LEFT" colspan="50"></th></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">IEC</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">0411021117</td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">IEC Allotment Date</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">15.09.2011</td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">File Number</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">04/08/130/02067/AM12/ </td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">File Date</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">14.09.2011</td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">IEC</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">0411021117</td></tr>
<tr><td valign="TOP" align="LEFT" colspan="50">Party Name and Address</td><td valign="TOP" align="LEFT" colspan="3">:</td><td valign="TOP" align="LEFT" colspan="50">KAMADHENU EXPORTS <br>NO. 638, LIG-1, MMDA <br>MATHUR, <br>CHENNAI <br>PIN-600068<br></td></tr>
I have to extract the text(highlightedbyme) which is in the 7th row of the first table. As here , there is no table name or id. please, provide me a code or idea of how to get the data and store it into one excel cell.
I'm a starter in this coding.
Tanks in advance.