Can we create bullets using aspose.excel?

Aspose.Cells Product Family
1

Hi there,

need some help here.

I need to create the text below into 1 cell in my excel sheet using Aspose.excel.

• text 1
• text 2
• text 3

is this possible ? how ? thanks!

Kelly

2

Yes, you can. Please try:

cells["A1"].PutValue("• text 1\n• text 2\n• text 3");
cells["A1"].Style.IsTextWrapped = true;
cells.SetRowHeight(0, 40);

3

Hi Lawrence,

is it possible to not fix the height ? cos' I will be reading from the db, appending the values to a string and then putvalue to a cell. So it'll be good if the cell can adjust itself so that all the text can be displayed.

thanks!

4

You can use Worksheet.AutoFitRow method.

5

Thanks Lawrence for your prompt reply! Smile [:)]