Smart marker HTML with Light cells data provider

Aspose.Cells Product Family
1

Morning everyone,


We are using aspose cells java (LighCellDataProvider) for generating excel.

We got a requirement to add HTML text for 1st cell of 1st row. But through LightCellDataProvider interface implementation we are unable to convert HTML.

Here is the code we are using.


if(rowIndex == 0){
cell.putValue("&=$VariableArray(HTML)");
designer.setWorkbook(this.writeWorkbook);
designer.setDataSource(“VariableArray”, values);
designer.process();
}

We are getting &=$VariableArray(HTML) in excel sheet only instead of data. Here values is the array of string contains HTML
2

Hi,


Thanks for your query.

As you might know, in LightCells mode, there are certain limitations with data model when reading or writing data. The LightCells API provides means and is mainly designed to manipulate cell data one by one without building a complete data model block into memory. For your information, when we process Smart Markers, we have to insert rows/columns first and fill data column by column, so parsing HTML in Smart Markers in LightCells mode cannot be supported as we got to load all data to parse HTML accordingly, so it is out of scope and cannot be supported.

If you want to use HTML Smart markers, you will not use it in LightCells mode.

Thank you.