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

Free Support Forum - aspose.com

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

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.



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.