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> [TABLE="width: 195"]
<colgroup><col style="width:65pt" span="3" width="87"> </colgroup><tbody>[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 411"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]TIME
[/TD]
[TD] 290 CPU %
[/TD]
[TD]Memory %[/TD]
[/TR]
[TR]
[TD="align: right"]20/02/18 20:00[/TD]
[TD="align: right"]12.77[/TD]
[TD="align: right"]62.53[/TD]
[/TR]
[TR]
[TD="align: right"]20/02/18 21:00[/TD]
[TD="align: right"]11.97[/TD]
[TD="align: right"]62.54[/TD]
[/TR]
[TR]
[TD="align: right"]20/02/18 22:00[/TD]
[TD="align: right"]12.26[/TD]
[TD="align: right"]62.48[/TD]
[/TR]
[TR]
[TD="align: right"]20/02/18 23:00[/TD]
[TD="align: right"]8.63[/TD]
[TD="align: right"]62.49[/TD]
[/TR]
[TR]
[TD="align: right"]21/02/18 0:00[/TD]
[TD="align: right"]3.46[/TD]
[TD="align: right"]62.47[/TD]
[/TR]
[TR]
[TD="align: right"]21/02/18 1:00[/TD]
[TD="align: right"]2.98[/TD]
[TD="align: right"]62.5[/TD]
[/TR]
[TR]
[TD="align: right"]21/02/18 2:00[/TD]
[TD="align: right"]2.52[/TD]
[TD="align: right"]62.49[/TD]
[/TR]
[TR]
[TD="align: right"]21/02/18 3:00[/TD]
[TD="align: right"]5.93[/TD]
[TD="align: right"]62.95[/TD]
[/TR]
</tbody>[/TABLE]
File 2
[TABLE="width: 409"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]TIME[/TD]
[TD]291 CPU %[/TD]
[TD]Memory %[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 0:00[/TD]
[TD="align: right"]2.05[/TD]
[TD="align: right"]24.47[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 1:00[/TD]
[TD="align: right"]2.8[/TD]
[TD="align: right"]24.5[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 2:00[/TD]
[TD="align: right"]2.87[/TD]
[TD="align: right"]24.5[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 3:00[/TD]
[TD="align: right"]2.38[/TD]
[TD="align: right"]24.53[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 4:00[/TD]
[TD="align: right"]2.45[/TD]
[TD="align: right"]24.55[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 5:00[/TD]
[TD="align: right"]3.79[/TD]
[TD="align: right"]25.48[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 6:00[/TD]
[TD="align: right"]3.21[/TD]
[TD="align: right"]25.37[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 7:00[/TD]
[TD="align: right"]2.48[/TD]
[TD="align: right"]24.61[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 8:00[/TD]
[TD="align: right"]2.47[/TD]
[TD="align: right"]24.63[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 9:00[/TD]
[TD="align: right"]2.52[/TD]
[TD="align: right"]24.65[/TD]
[/TR]
</tbody>[/TABLE]
and so on..
Output needs to be in a single xls file
Pls guide as to how to do it.
[TABLE="width: 195"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 195"]
<tbody>[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 195"]
<tbody>[TR]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 195"]
<tbody></tbody>[/TABLE]
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> [TABLE="width: 195"]
<colgroup><col style="width:65pt" span="3" width="87"> </colgroup><tbody>[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 411"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]TIME
[/TD]
[TD] 290 CPU %
[/TD]
[TD]Memory %[/TD]
[/TR]
[TR]
[TD="align: right"]20/02/18 20:00[/TD]
[TD="align: right"]12.77[/TD]
[TD="align: right"]62.53[/TD]
[/TR]
[TR]
[TD="align: right"]20/02/18 21:00[/TD]
[TD="align: right"]11.97[/TD]
[TD="align: right"]62.54[/TD]
[/TR]
[TR]
[TD="align: right"]20/02/18 22:00[/TD]
[TD="align: right"]12.26[/TD]
[TD="align: right"]62.48[/TD]
[/TR]
[TR]
[TD="align: right"]20/02/18 23:00[/TD]
[TD="align: right"]8.63[/TD]
[TD="align: right"]62.49[/TD]
[/TR]
[TR]
[TD="align: right"]21/02/18 0:00[/TD]
[TD="align: right"]3.46[/TD]
[TD="align: right"]62.47[/TD]
[/TR]
[TR]
[TD="align: right"]21/02/18 1:00[/TD]
[TD="align: right"]2.98[/TD]
[TD="align: right"]62.5[/TD]
[/TR]
[TR]
[TD="align: right"]21/02/18 2:00[/TD]
[TD="align: right"]2.52[/TD]
[TD="align: right"]62.49[/TD]
[/TR]
[TR]
[TD="align: right"]21/02/18 3:00[/TD]
[TD="align: right"]5.93[/TD]
[TD="align: right"]62.95[/TD]
[/TR]
</tbody>[/TABLE]
File 2
[TABLE="width: 409"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]TIME[/TD]
[TD]291 CPU %[/TD]
[TD]Memory %[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 0:00[/TD]
[TD="align: right"]2.05[/TD]
[TD="align: right"]24.47[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 1:00[/TD]
[TD="align: right"]2.8[/TD]
[TD="align: right"]24.5[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 2:00[/TD]
[TD="align: right"]2.87[/TD]
[TD="align: right"]24.5[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 3:00[/TD]
[TD="align: right"]2.38[/TD]
[TD="align: right"]24.53[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 4:00[/TD]
[TD="align: right"]2.45[/TD]
[TD="align: right"]24.55[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 5:00[/TD]
[TD="align: right"]3.79[/TD]
[TD="align: right"]25.48[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 6:00[/TD]
[TD="align: right"]3.21[/TD]
[TD="align: right"]25.37[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 7:00[/TD]
[TD="align: right"]2.48[/TD]
[TD="align: right"]24.61[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 8:00[/TD]
[TD="align: right"]2.47[/TD]
[TD="align: right"]24.63[/TD]
[/TR]
[TR]
[TD="align: right"]01/01/18 9:00[/TD]
[TD="align: right"]2.52[/TD]
[TD="align: right"]24.65[/TD]
[/TR]
</tbody>[/TABLE]
and so on..
Output needs to be in a single xls file
Pls guide as to how to do it.
[TABLE="width: 195"]
<tbody>[TR]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 195"]
<tbody>[TR]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 195"]
<tbody>[TR]
[TD="width: 87"][/TD]
[TD="width: 87"][/TD]
[TD="class: xl63"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 195"]
<tbody></tbody>[/TABLE]