Free Support Forum - aspose.com

Support fot <br> tag in aspose.cells

I have a dynamic data containing two parts with
tag in it. whenever i get a
tag , i need to display the data after
tag in next line. If I put the data into cell using cell.putvalue[ ], even the
tag is displayed in cell. I searched for the support of
tag in aspose.cells and found sheet.cell[].htmlstring = data; supports that. But the problem is that , in the resultant cell the
tag is not displaying but the data after
tag is not coming to next line. Please suggest me something.

Hi,


I think you may try (you should set text wrapping on), see the lines in bold.

Sample code:

Aspose.Cells.Workbook xlWorkbook = new Aspose.Cells.Workbook();
Aspose.Cells.Worksheet xlWorkSheet = xlWorkbook.Worksheets[0];
Cells cells = xlWorkSheet.Cells;
cells[“A1”].HtmlString = “Hello there,
this is a second sample text”;
Style style = cells[“A1”].GetStyle();
style.IsTextWrapped = true;
cells[“A1”].SetStyle(style);

xlWorkSheet.Cells.SetColumnWidth(0, 25);
xlWorkSheet.AutoFitRow(0);

xlWorkbook.Save(“e:\test2\Mysamplestring1.xlsx”);

Moreover, please see the documents in the section on how to apply style/formatting for different needs/options:
http://www.aspose.com/docs/display/cellsnet/Working+with+Data+Formatting

Thank you.