Aspose.Cell's HtmlString proerty issues:

Aspose.Cells Product Family
1

Hi there,

here is the sample code i used to test aspose.cell and make utilize component in my application. The main usage in component is HtmlString property of Cell to insert HTML content in a cell. some times my HTML content could be bit complex.

oCell = oWorksheet.Cells[1, 2];
oCell.HtmlString = “Welcome”; // OK
oCell = oWorksheet.Cells[4, 2];
oCell.HtmlString = “Welcome
Srinu”; // Not OK: displaying like Welcome + sqare box + srinu
oCell = oWorksheet.Cells[6, 2];
oCell.HtmlString = “test Image
”; // Not OK: displaying like test Image + sqare box, i didn’t see any image here even image is available at given path
oCell = oWorksheet.Cells[8, 2];
oCell.HtmlString = “test Table

first column second column
1 2
”; // Not OK; displaying like
test Tablefirst columnsecond column12


oXLSDoc.Save(@"D:\testExcel.xls");

Could you please suggest me how can i see this html output in a Cell like how we are seeing the same html on web page? Is there any Aspose.Cell properties/methods to achieve my requirement??

Thanks,

2

Hi,

Well, I am afraid, the Html tags/attributes like Br, Table, Img are not supported. These will be supported after we incorporate Import Html feature to the product.
Anyways, I have logged it into our issue tracking system with an issue id: CELLSNET-17515.


By the way, I think you may use Style formatting options (provided by Aspose.Cells API) to format your selective data in a cell, you can use borders options to implement table attributes. Similarly you can insert images using Aspose.Cells for .NET API. I will mention here some documents for your reference:

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/formatting-selected-characters-in-a-cell.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/adding-borders-to-cells.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/configuring-alignment-settings.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/line-break-and-text-wrapping.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/adding-pictures.html


Thank you.

3

Hi, can i know for which HTML tags it will not support , i.e u told that , like
,

are not supported,
is there any other tags is there ? can u please send that list.
or if it is working fine to all tags then provide that version name.for purchasing.

Thanks in advance
Bhupal


4

Hi,


We did support some more Htmt Tags in HtmlString proprty in recent versions. We recommend you to use Aspose.Cells for .NET v6.0.1.9: Please download: Aspose.Cells for .NET v6.0.1.9

If there are some html tags that are still not supported and you need them urgently, we will try to support the tags one by one.

Thank you.
5

Hi,


I need tag very urgently.

Can you please help me out in this?

Thanks,
Tabs
6
Tabs:
Hi,

I need tag very urgently.

Can you please help me out in this?

Thanks,
Tabs
Hi,

I have logged a New Feature Request in our database to support this tag. We will look into it and implement this feature and update you asap.

This issue has been logged as CELLSNET-40948.
7

Hi,

Thanks for using Aspose.Cells.

We could not support img tag in Cell. HtmlString value.

We
have supported reading html file with new Workbook.

C#


Workbook workbook = new Workbook(“c:\source.html”);

8

Hi Shakeel,


Can you provide me the example how exactly the workbook helps in using and other html tags?


Thanks in advance,
Tabs
9

Hi Shahista,


I am afraid, html tag is still not supported. We are sorry for any inconvenience caused.

By the way, you may insert images/pictures using Aspose.Cells APIs if you want, see the document / article for your reference:
http://www.aspose.com/docs/display/cellsnet/Adding+Pictures

Thank you.

10

Thanks for the quick response.


I am using the suggested approach to add images in few pages but in other, i need to add images in between the text.
Ex: ABCXYZ

Can you suggest me a good approach to resolve this issue?

Thanks.
11

Hi,


Well, I am afraid, as we told you we do not support tag in HTML format, we might not support it in near future as well. At the moment, you may only use Aspose.Cells APIs to add pictures or images to the cells as per MS Excel.

We are sorry for your inconvenience caused!