Html into template - additional information in td

I would like to check if there is any option to “load” over HTML additional information like “name” or “tag” so I can get their information while converting the HTML to the workbook

For example - while we autofit all the rows in the range, I would like to set special heights for specific rows.

current flow today is: load the HTML into the temp workbook, then copy the rows into the final workbook (template) then autofit rows in the excel file.
In that process, I would like to keep the special information till I complete the autofit so that I will be able to reset the height for the special rows.

in that example - the row with the data “accounting company” - should be with a custom hight
image.png (69.0 KB)

@zivdaniel,

Thanks for the screenshot.

There is no such option/API for HTML data in Aspose.Cells. I do not think there are any means in MS Excel either. If you know any, let us know and we can check it.

You are doing ok. You may record/store the information into variables/objects and later on you may use it accordingly.

Hi, thanks
related to the height
I’ve manage to set the height in the file using the mso-* attribute. and with that - I’ve managed to control the height.
there is any document for the html for what you supporting? or how we should implement the html? (only mso? classes are working? what are the limitations?)

@zivdaniel,

Good to know that you have sorted it out for height.

Please note, Aspose.Cells follows MS Excel standards and specifications when parsing/rendering HTML files. Aspose.Cells supports to create/render MS Excel oriented HTML files. So, when you specify html string/tags in the file, this should be supported in MS Excel or MS Excel should parse it fine. For your information, not all HTML tags or common HTML are supported by MS Excel or Aspose.Cells. Aspose.Cells can parse those HTML tags which are understood/parsed by MS Excel.

There is no such document in the Docs. Anyways, we will provide more details on it.

Hi, may you encounter how to set column width from HTML to xlsx?

@zivdaniel,

Generally, we follow MS Excel standards and specifications when parsing or rendering HTMLs. You may open a workbook and set some custom widths for the columns. Now save the file as HTML (“Web page”). You may examine the HTML source (file(s)) for the attributes specified for column widths and row heights for it.