Convert string to numbers and apply numbers style/formatting in Excel .NET

Aspose.Cells Product Family
1

I am using Style.Number = 1 to format the cell as an integer.



For example:



workbook.worksheets(0).cells(0,0).Style.Number = 1



But when i SaveType.OpenInExcel it has all the little green triangles and it requires the user to convert them to numbers. Is there a way to make sure the formatting takes so the green triangle does not show up.



I am using Excel 2007 if that is an issue.



Thanks.

2

Hi,

I think you must set a string value to cell.If you want to convert it to a number value, please use Cell.PutValue(stringValue, true) method to set the cell value.