We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Percent- number- date- ... cell style


How can i set the cell style to percent, number or date for exemple ?

I know that some version of Excel had a limit of style number, if i apply 3 times the same style for 3 differents cells does Excel count only one style or 3 differents styles ?



Thanks for considering Aspose.

Please check for your reference: http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/NumberFormat.html

And if you have to apply same formattings to a range of cells, you 'd better create a style object, set its formattings attributes and apply it to those range of cells.

Workbook workbook = new Workbook();
Worksheet sheet1 = workbook.Worksheets[0];
Cells cells = sheet1.Cells;
//Creating a style object and apply it to some cells.
Style style = workbook.Styles[workbook.Styles.Add()];
style.Custom = "0%";
cells["A1"].Style = style;
cells["A2"].Style = style;
Further reference: http://www.aspose.com/Wiki/default.aspx/Aspose.Cells/PerformanceTips.html
Thank you.


It seems that if i want to format cell to number, date i need to do a PutValue with the right type.

Exemple :

To format a cell to numeric, i need to apply format style value to 0 AND also do a PutValue of an integer.

My main problem is that i don't know the type of the data to write in the cell, so i handle everything like a string.

It is possible to handle yourself the different cast ?

If i do a PutValue(object), is Aspose.Cells do the cast by itself ?



I think you may use the following overloaded version of Cell.PutValue() method:

public void PutValue(
string stringValue,
bool isConverted


Input value
True: converted to other data type if appropriate.

Thank you.

Thanks a lot for your answer