MatrixBoy2
New Member
- Joined
- Aug 17, 2009
- Messages
- 1
HTML markup to add comments to excel cell
Hi,
I want to create an html string such that if I just paste that html string
into an excel sheet it will add a comment to one cell. Something like:
<table>
<tr>
<td ss:Comment="This is my comment text">my cell text</td>
<td>another cell</td>
</tr>
</table>
In the above example the text "This is my comment text" should become
a comment in the excel cell with text "my cell text".
Is this possible? If so, what is the markup to use?
I know that I could use something like the code below to add comments, but would rather not.
<div style='mso-element:comment'>
<div>
<!--[if gte mso 9]><xml>
<v:shapetype id="_x0000_t202" coordsize="21600,21600" o:spt="202" path="m,l,21600r21600,l21600,xe">
<v:stroke joinstyle="miter"/>
<vath gradientshapeok="t" o:connecttype="rect"/>
</v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t202" style='position:absolute;
margin-left:107.25pt;margin-top:1.5pt;width:96pt;height:55.5pt;z-index:1;
visibility:hidden' fillcolor="#ffffe1" o:insetmode="auto">
<v:fill color2="#ffffe1"/>
<v:shadow on="t" color="black" obscured="t"/>
<vath o:connecttype="none"/>
<v:textbox style='mso-direction-alt:auto'/>
<x:ClientData ObjectType="Note">
<x:MoveWithCells/>
<x:SizeWithCells/>
<x:AutoFill>False</x:AutoFill>
<x:Row>0</x:Row>
<x:Column>1</x:Column>
<x:Author>23059278</x:Author>
</x:ClientData>
</v:shape></xml><![endif]-->
<div v:shape="_x0000_s1025" style='padding:.75pt 0pt 0pt .75pt;text-align:left'
class=shape><font class="font6">23059278:</font><font class="font5"><br>
This is my comment</font></div>
</div>
</div>
Any help is greatly appreciated!
Regards
/Christoffer
Hi,
I want to create an html string such that if I just paste that html string
into an excel sheet it will add a comment to one cell. Something like:
<table>
<tr>
<td ss:Comment="This is my comment text">my cell text</td>
<td>another cell</td>
</tr>
</table>
In the above example the text "This is my comment text" should become
a comment in the excel cell with text "my cell text".
Is this possible? If so, what is the markup to use?
I know that I could use something like the code below to add comments, but would rather not.
<div style='mso-element:comment'>
<div>
<!--[if gte mso 9]><xml>
<v:shapetype id="_x0000_t202" coordsize="21600,21600" o:spt="202" path="m,l,21600r21600,l21600,xe">
<v:stroke joinstyle="miter"/>
<vath gradientshapeok="t" o:connecttype="rect"/>
</v:shapetype><v:shape id="_x0000_s1025" type="#_x0000_t202" style='position:absolute;
margin-left:107.25pt;margin-top:1.5pt;width:96pt;height:55.5pt;z-index:1;
visibility:hidden' fillcolor="#ffffe1" o:insetmode="auto">
<v:fill color2="#ffffe1"/>
<v:shadow on="t" color="black" obscured="t"/>
<vath o:connecttype="none"/>
<v:textbox style='mso-direction-alt:auto'/>
<x:ClientData ObjectType="Note">
<x:MoveWithCells/>
<x:SizeWithCells/>
<x:AutoFill>False</x:AutoFill>
<x:Row>0</x:Row>
<x:Column>1</x:Column>
<x:Author>23059278</x:Author>
</x:ClientData>
</v:shape></xml><![endif]-->
<div v:shape="_x0000_s1025" style='padding:.75pt 0pt 0pt .75pt;text-align:left'
class=shape><font class="font6">23059278:</font><font class="font5"><br>
This is my comment</font></div>
</div>
</div>
Any help is greatly appreciated!
Regards
/Christoffer
Last edited: