Hello
I am trying to extract data from a webpage (see below sample html) to an excel.
Some "Details" have multiple lines so I cannot handpick values.
What is the best way to achieve that?
I am quite confused with the CSS tags etc (suggested reading welcome)
<!DOCTYPE html>
<html>
<head>
<title>Title</title>
</head>
<body>
<div class="logo">
<img src="/images/Banner.png"
alt="alt name" title="ALT NAME" />
</div>
</body>
</html>
<div id="mainContent">
<div> </div>
<h1 id="infoHeader">Information about </h1>
<div>
<a >xxxxx</a>
</div>
<div class="clearBoth"></div>
<div class="Info">
<fieldset>
<legend>Details 1</legend>
<table class="table">
<tbody>
<tr>
<th>Label 1</th> <td>Data 1</td>
<th>Label 2</th> <td>Data 2</td>
</tr>
<tr>
<th>Label 3</th> <td>Data 3</td>
<th>Label 4</th> <td>Data 4</td>
</tr>
<tr>
<th>Label 5</th> <td>Data 5</td>
<th>Label 6</th> <td>Data 6</td>
</tr>
<tr>
<th>Label 7</th> <td>Data 7</td>
<th>Label 8</th> <td>Data 8</td>
</tr>
<tr>
<th>Label 9</th> <td colspan="3">Data 9</td>
</tr>
</tbody>
</table>
</fieldset>
<fieldSet>
<legend>Details 2</legend>
<ul>
<li><span>Label 10</span><span>Label 11</span><span>Label 12</span><span>Label 13</span></li>
</ul>
<ol>
<li><span> Data 10</span><span> Data 11</span><span> Data 12</span><span> Data 13</span></li>
</ol>
</fieldSet>
<fieldSet>
<legend>Details 3</legend>
<ul>
<li><span>Label 14</span><span>Label 15</span><span>Label 16</span><span>Label 17</span><span>Label 18</span><span>Label 19</span></li>
</ul>
<ol>
<li><span> Data14-1</span><span> Data 15-1</span><span> Data 16-1</span><span> Data 17-1</span><span> Data 18-1</span><span> Data 19-1</span></li>
<li><span> Data14-2</span><span> Data 15-2</span><span> Data 16-2</span><span> Data 17-2</span><span> Data 18-2</span><span> Data 19-2</span></li>
</ol>
</fieldSet>
</div>
</body>
</html>
