Hi
I have a table like this:
<table border="0" cellpadding="0" cellspacing="0" width="299"><col style="width: 80pt;" width="107"> <col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 80pt;" width="107" height="17">A</td> <td class="xl25" style="width: 48pt;" width="64">B</td> <td class="xl25" style="width: 48pt;" width="64">C</td> <td class="xl25" style="width: 48pt;" width="64">D</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Job</td> <td class="xl27">Start</td> <td class="xl27">End</td> <td class="xl27">Amount</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Rent paid - 1</td> <td class="xl26" align="right">6/1/2011</td> <td class="xl26" align="right">8/31/2011</td> <td class="xl24" align="right">800</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Rent paid - 2</td> <td class="xl26" align="right">9/1/2011</td> <td class="xl26" align="right">1/31/2012</td> <td class="xl24" align="right">1000</td> </tr> </tbody></table>
I would like transform this data in a format like this (something like a Gantt chart, but with the amount in the "End" month column:
<table border="0" cellpadding="0" cellspacing="0" width="512"><col style="width: 48pt;" width="64" span="8"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 48pt;" width="64" height="17">A</td> <td class="xl25" style="width: 48pt;" width="64">B</td> <td class="xl25" style="width: 48pt;" width="64">C</td> <td class="xl25" style="width: 48pt;" width="64">D</td> <td class="xl25" style="width: 48pt;" width="64">E</td> <td class="xl25" style="width: 48pt;" width="64">F</td> <td class="xl25" style="width: 48pt;" width="64">G</td> <td class="xl25" style="width: 48pt;" width="64">H</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt;" height="17">Jun</td> <td class="xl26">Jul</td> <td class="xl26">Aug</td> <td class="xl26">Sep</td> <td class="xl26">Oct</td> <td class="xl26">Nov</td> <td class="xl26">Dec</td> <td class="xl26">Jan</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl28" align="right">800</td> <td class="xl24"> </td> <td class="xl24"> </td> <td class="xl24"> </td> <td class="xl24"> </td> <td class="xl24"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17"> </td> <td class="xl24"> </td> <td class="xl24"> </td> <td class="xl29"> </td> <td class="xl29"> </td> <td class="xl29"> </td> <td class="xl29"> </td> <td class="xl30" align="right">1000</td> </tr> </tbody></table>
Well, the colors are not being copied here...but there A2 through C2 should be filled-in by a color, and D3 through H3 should be filled-in by a color as well.
Appreciate your help in advance.
MK
I have a table like this:
<table border="0" cellpadding="0" cellspacing="0" width="299"><col style="width: 80pt;" width="107"> <col style="width: 48pt;" width="64" span="3"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 80pt;" width="107" height="17">A</td> <td class="xl25" style="width: 48pt;" width="64">B</td> <td class="xl25" style="width: 48pt;" width="64">C</td> <td class="xl25" style="width: 48pt;" width="64">D</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17">Job</td> <td class="xl27">Start</td> <td class="xl27">End</td> <td class="xl27">Amount</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Rent paid - 1</td> <td class="xl26" align="right">6/1/2011</td> <td class="xl26" align="right">8/31/2011</td> <td class="xl24" align="right">800</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">Rent paid - 2</td> <td class="xl26" align="right">9/1/2011</td> <td class="xl26" align="right">1/31/2012</td> <td class="xl24" align="right">1000</td> </tr> </tbody></table>
I would like transform this data in a format like this (something like a Gantt chart, but with the amount in the "End" month column:
<table border="0" cellpadding="0" cellspacing="0" width="512"><col style="width: 48pt;" width="64" span="8"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 48pt;" width="64" height="17">A</td> <td class="xl25" style="width: 48pt;" width="64">B</td> <td class="xl25" style="width: 48pt;" width="64">C</td> <td class="xl25" style="width: 48pt;" width="64">D</td> <td class="xl25" style="width: 48pt;" width="64">E</td> <td class="xl25" style="width: 48pt;" width="64">F</td> <td class="xl25" style="width: 48pt;" width="64">G</td> <td class="xl25" style="width: 48pt;" width="64">H</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl26" style="height: 12.75pt;" height="17">Jun</td> <td class="xl26">Jul</td> <td class="xl26">Aug</td> <td class="xl26">Sep</td> <td class="xl26">Oct</td> <td class="xl26">Nov</td> <td class="xl26">Dec</td> <td class="xl26">Jan</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl27" style="height: 12.75pt;" height="17"> </td> <td class="xl27"> </td> <td class="xl28" align="right">800</td> <td class="xl24"> </td> <td class="xl24"> </td> <td class="xl24"> </td> <td class="xl24"> </td> <td class="xl24"> </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17"> </td> <td class="xl24"> </td> <td class="xl24"> </td> <td class="xl29"> </td> <td class="xl29"> </td> <td class="xl29"> </td> <td class="xl29"> </td> <td class="xl30" align="right">1000</td> </tr> </tbody></table>
Well, the colors are not being copied here...but there A2 through C2 should be filled-in by a color, and D3 through H3 should be filled-in by a color as well.
Appreciate your help in advance.
MK
