Hi,
I am new to the forum and heard a lot about it. I am sure, I will get answer to my query, which I am struggling to solve. Here it goes
I have 1000's of xls files where I am trying to fetch the information of 3 columns and corresponding rows into a new xls file. How to do it without using VBA.
Example
File 1
<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { }</style>
<colgroup><col style="width:65pt" span="3" width="87"> </colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody>
</tbody>
File 2
<colgroup><col><col><col></colgroup><tbody>
</tbody>
and so on..
Output needs to be in a single xls file
Pls guide as to how to do it.
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
<tbody></tbody>
I am new to the forum and heard a lot about it. I am sure, I will get answer to my query, which I am struggling to solve. Here it goes
I have 1000's of xls files where I am trying to fetch the information of 3 columns and corresponding rows into a new xls file. How to do it without using VBA.
Example
File 1
<style>table { }tr { }col { }br { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { }</style>
<colgroup><col style="width:65pt" span="3" width="87"> </colgroup><tbody>
</tbody>
TIME | 290 CPU % | Memory % |
20/02/18 20:00 | 12.77 | 62.53 |
20/02/18 21:00 | 11.97 | 62.54 |
20/02/18 22:00 | 12.26 | 62.48 |
20/02/18 23:00 | 8.63 | 62.49 |
21/02/18 0:00 | 3.46 | 62.47 |
21/02/18 1:00 | 2.98 | 62.5 |
21/02/18 2:00 | 2.52 | 62.49 |
21/02/18 3:00 | 5.93 | 62.95 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
File 2
TIME | 291 CPU % | Memory % |
01/01/18 0:00 | 2.05 | 24.47 |
01/01/18 1:00 | 2.8 | 24.5 |
01/01/18 2:00 | 2.87 | 24.5 |
01/01/18 3:00 | 2.38 | 24.53 |
01/01/18 4:00 | 2.45 | 24.55 |
01/01/18 5:00 | 3.79 | 25.48 |
01/01/18 6:00 | 3.21 | 25.37 |
01/01/18 7:00 | 2.48 | 24.61 |
01/01/18 8:00 | 2.47 | 24.63 |
01/01/18 9:00 | 2.52 | 24.65 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
and so on..
Output needs to be in a single xls file
Pls guide as to how to do it.
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
<tbody></tbody>