Formatting inside a cell

hi,
i’d like to know if it is possible to have multiple styles within a cell, eg a cell with content " bold part italic part normal part "

Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Cell.Characters.html
for reference.

hi,
it seems as soon as i use the characters() function it corrupts the data in that cell.

i’m downloading as excel97 format and opening in excel 2003

Please download and try the latest version at

@hemant,
Aspose.Cells has replaced Aspose.Excel that is no more actively developed now. This new product supports all the latest features available in different versions of MS Excel. You can format data in a variety of ways like setting display format of numbers and dates, formatting rows and columns, and formatting selected characters in a cell. Here is an example that demonstrates the feature of formatting selected characters in a cell.

// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Obtaining the reference of the first(default) worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[0];

// Accessing the "A1" cell from the worksheet
Cell cell = worksheet.Cells["A1"];

// Adding some value to the "A1" cell
cell.PutValue("Visit Aspose!");

// Setting the font of selected characters to bold
cell.Characters(6, 7).Font.IsBold = true;

// Setting the font color of selected characters to blue
cell.Characters(6, 7).Font.Color = Color.Blue;

// Saving the Excel file
workbook.Save("book1.out.xls");

Here is the program output:

For more details on formatting data, refer to the following article:
Data Formatting

Here you can download the latest free trial version of this new product:
Aspose.Cells for .NET (Latest Version)

You can test all the features of this product by downloading a runnable solution here.