Writing HTML to Aspose.Cell

Aspose.Cells Product Family
1

Please let me know can I put a HTML script like

Hi SirhelloMr. ABCdef(Contrater)of some companycalled LLL onefjin US

in a Excel Cell using ASPOSE that should be displayed as.

Hi SirhelloMr. ABCdef(Contrater)of some companycalled LLL onein US

Or I have manupulate it by using Charater object of Cell and according set the text.

If you have any code snippet which can convert this thing I shall be very grateful.

2

Aspose.Cells doesn’t support to format html in a cell. You have to set the text by your own code, please check Rich Text.

3

According to this we can only format basics but not ordered lists, bullet tags, font faces etc. If some thing like putHTML which can auto format based on HTML will be very useful. We desperatly need this feature as we are loosing tags, ordered list while pasing data throgh Aspose it displays complete HTML in the cell. If this feature is not supported it will preclude us to implement Aspose. Please tell us are you going to give its solution in upcoming releases if yes then in how much time.

4

If your html strings are similiar to:

Hi SirhelloMr. ABCdef(Contrater)of some companycalled LLL onefjin US

We can make it in 2-3 weeks. However, if they contains more html tags, it will be much more complex. Could you post a sample html string to show your other needs?

5

Has any progress been made in allowing ordered lists and bullet tags to be formatted and read in Excel using Aspose cells? Thanks!

6

Hi,

Well, I am afraid Aspose.Cells does not parse html tags, we could not have time to work on the feature yet. We can look into the feature in future though.

Thank you.

7

Hi
any improvement to aspose.cell.HTMLString ,

Now will it converts br, image, table, bullets and orderlist , Font Face, background color and others to HTML or still it is in fixing.

Please Provide information about converting these things to HTMl and HTML to Excel cell by using Aspose.Cell.HtmlSting

Bhupal

8

Hi Bhupal,


Well, image, table tags are not supported. Other tags regarding br, html lists, font (with its attributes) are supported. Moreover, for HtmlString attribute, we only accept cell values, other objects are not supported.

Thank you.
9

Hi Thanks for response Amjad,


Only Image and Table tags are not worked as per this dll, so other tags works fine for HtmlString , then that is good to here from ur side.

Can u please clarify that

cell.HtmlString=“

  • one
  • Two
  • Three
  • Four
”;



will it works with the latest version of Apose.Cell dll

and HtmlString will gets the same code for the number bullets in the Excel cell as shown row 5 and column 1

or can i know solution for this type of values how to convert this to html order list
i tried it not coming as order list using HtmlString





Please provide information for that

thanks
Bhupal
10

Hi

HtMlString is not giving
code for new line in the cell and it is not creating any order list or unorder list for multiple lines

can u check once what i post

11

Hi,


Please give us your source Excel file here, we will check Cell.HtmlString attribute with it.
If we found the issue, we will log it into our Issue tracking system.

Thank you.
12

Hi cau u check by using the HtmlString this attached xls file for different types

i given times new roman and orders list

and i tried giving

    and


    it displaying a square box between data ,how to solve that problem

    So for this can send that HTML Code for each cell then I can proceed to next

    Thanks





13

Hi,


Well, I can see Backcolor and wrapping text attributes missing. I think you may try the following sample code as a workaround and we will look into backcolor and line breaks issue soon.
Sample code:
Workbook workbook = new Workbook(“e:\test2\Courier.xls”);
Worksheet worksheet = workbook.Worksheets[0];
Cells cells = worksheet.Cells;
MessageBox.Show(worksheet.Cells[“A5”].HtmlString);
MessageBox.Show(worksheet.Cells[“B6”].HtmlString);
MessageBox.Show(worksheet.Cells[“A7”].HtmlString);

Style style = null;

//Assign html tags to different cells using htmlstring
//Back color and wrapping text formatting is missing, so we can do it manually as a workaround.

worksheet.Cells[“A15”].HtmlString = worksheet.Cells[“A5”].HtmlString;
style = worksheet.Cells[“A5”].GetStyle();
style.IsTextWrapped = true;
worksheet.Cells[“A15”].SetStyle(style);
worksheet.Cells[“B16”].HtmlString = worksheet.Cells[“B6”].HtmlString;
style = worksheet.Cells[“B6”].GetStyle();
style.IsTextWrapped = true;
worksheet.Cells[“B16”].SetStyle(style);
worksheet.Cells[“A17”].HtmlString = worksheet.Cells[“A7”].HtmlString;
style = worksheet.Cells[“A7”].GetStyle();
style.IsTextWrapped = true;
worksheet.Cells[“A17”].SetStyle(style);
worksheet.AutoFitRows();
workbook.Save(“e:\test2\out_Courier.xls”);



Thank you.
14

Do

    and
  • tags work in the latest ASPOSE.CELLS version?


    e.g.
    • Text 1
15

Hi saadullah.kashif,


Well, these tags are not supported. Also, I think MS Excel does not support these tags as well. Could you create an HTML file with your desired formatting in MS Excel manually and post us here, we will check its source if we can support it.

Thank you.