Hi Amjad,
This is Yatish here again. Thanks for your response.
Let me explain the problem to you once again, as i believe we still have some gap on that front, as the solution suggested is still far off from the one I am looking for.
I have a spreadsheet with some data in it. I do not want to show any HTML output in it. Only when I convert it to HTML, I want to embed some more HTML tags in it just before converting, so that the HTML that I get after conversion has few additional things (HTML) than the spreadsheet. (Earlier, simply setting cell value to that tag was simply working which is not the case now).
To give you an example:
Suppose my spreadsheet has value “Amjad” in cell (1,1)
Before converting to HTML, I was setting the value as
wBook.Worksheets[0].Cells[1, 1].Value = “
” + wBook.Worksheets[0].Cells[1, 1].StringValue + “
”;
This used to emit correct HTML like following to me:
"<td class=x32 width=97 style=‘width:72.75pt;’> Amjad
</td>“
Now after the updated version, I am getting following HTML which is causing the problem to me:
”<td class=x32 width=97 style=‘width:72.75pt;’><div class = ‘dummyDisableTextSelection’ style=‘display:inline;cursor:hand’> Amjad </div></td>"
I tried setting HtmlString property as suggested by you
wBook.Worksheets[0].Cells[1, 1].
HtmlString = "
" + wBook.Worksheets[0].Cells[1, 1].StringValue + "
";
but it did not help, as it is emitting following HTML now:
"<td class=x25 width=97 style='width:72.75pt;'> Amjad </td>"
I hope my problem is clear to you now. I am not looking for any HTML embedding in Spreadsheet, rather, I am looking to embed some additional HTML in cells, just before converting spreadsheet to HTML, so that I get a converted HTML as per my requirement.
Thanks and Regards,
Yatish