Aspose Number and date settings

A very powerful feature of Microsoft Excel is the ability for customers to set the display format of numbers and dates, which are known to be displayed in different value formats, including: decimals, currencies, percentages, fractions, book value, etc. The same aspose.cells provides developers with the ability to format numbers and Time. In excel, customers can right-click cells, Select cell formatting to format cells, and Aspose.cells provides GetStyle and SetStyle methods that are specifically designed to format cells.  aspose.cells also provides developers with a number of inline numeric and date formats that developers can invoke by using the number property of the style object, and the following is a list of the inline display formats provided by the Aspose.cells: Value  type  format String0  general  general1  decimal  02  decimal  0.003   Decimal  #,# #04  decimal  #,# #0.005  currency  $#,# #0; $-#,# #06  currency  $#,# #0; [red]$-#,# #07  currency  $#,# #0.00;$-#,# #0.008  currency  $#,# #0.00; [red]$-#,# #0.009  percentage  0%10  percentage  0.00%11  scientific  0.00E+0012   Fraction  #?/?13  fraction  #/14  date  m/d/yy15  date  d-mmm-yy16  Date   D-mmm17  date  mmm-yy18  time  h:mm am/pm19  time  h:mm:ss AM/PM20  Time  h:mm21  time  h:mm:ss22  time  m/d/yy h:mm37  currency  #,# #0;-#,# #038  Currency  #,# #0; [red]-#,# #039  currency  #,# #0.00;-#,# #0.0040  currency  #,# #0.00; [red]-#,# #0.0041  accounting  _ * #,# #0_; _ * "_; _ @_42  accounting  _ $* #,# #0_; _ $*" _; _ @_43 &NB Sp Accounting  _ * #,# #0.00_; _ * "?? _; _ @_44  accounting  _ $* #,# #0.00_; _ $* "?? _; _ @_45  time  mm:ss46  time  h:mm:ss47  time  mm:ss.048  Scientific  # #0.0E+0 049  text  @ We can actually see how to use these inline cell display formats using the following code://instantiating a Workbook objectworkbook Workbook = new Workbook ();//adding A new worksheet to the Workbook objectint i = Workbook. Worksheets.add ();//obtaining The reference of the newly added worksheet by passing its sheet indexworksheet worksheet = wo Rkbook. Worksheets[i];//adding the current system, date to "A1" cellworksheet. Cells["A1"]. Putvalue (datetime.now);//getting The Style of the A1CellStyle style = Worksheet. Cells["A1"]. GetStyle ();//setting The display format to number A to show date as "d-mmm-yy" Style. Number = 15;//applying The style to the A1 cellworksheet. Cells["A1"]. SetStyle (style);//adding A numeric value to "A2" cellworksheet. Cells["A2"]. Putvalue//getting the Style of the A2 CellStyle = Worksheet. Cells["A2"]. GetStyle ();//setting The display format to number 9 to show value as Percentagestyle. Number = 9;//applying The style to the A2 cellworksheet. Cells["A2"]. SetStyle (style);//adding A numeric value to "A3" cellworksheet. Cells["A3"]. Putvalue (2546);//getting The Style of the A3 CellStyle = Worksheet. Cells["A3"]. GetStyle ();//setting The display format to number 6 to show value as Currencystyle. Number = 6;//applying The style to the A3 cellworksheet. Cells["A3"]. SetStyle (style);//saving the Excel fileworkbook. Save ("c:\\book1.xls", saveformat.excel97to2003); Of course the developer can also set a custom display style for the cell, and the following code gives an example of how to set a cell custom display style://instantiating a Workbook Objectworkbook Workbook =New Workbook ();//adding A new worksheet to the Excel objectint i = Workbook. Worksheets.add ();//obtaining The reference of the newly added worksheet by passing its sheet indexworksheet worksheet = wo Rkbook. Worksheets[i];//adding the current system, date to "A1" cellworksheet. Cells["A1"]. Putvalue (datetime.now);//getting The style of A1 cellstyle style = Worksheet. Cells["A1"]. GetStyle ();//setting The custom display format to show date as "d-mmm-yy" Style. Custom = "d-mmm-yy";//applying The style to A1 Cellworksheet. Cells["A1"]. SetStyle (style);//adding A numeric value to "A2" cellworksheet. Cells["A2"]. Putvalue;//getting the style of A2 CellStyle = Worksheet. Cells["A2"]. GetStyle ();//setting The custom display format to show value as Percentagestyle. Custom = "0.0%";//applying The style to A2 Cellworksheet. Cells["A2"]. SetStyle (style);//adding A numeric value to "A3" cellworksheet. Cells["A3"]. Putvalue (2546);//getting The style of A3 CellStyle = Worksheet. Cells["A3"]. GetStyle ();//setting the Custom display format to show value as Currencystyle. Custom = "￡#,# #0; [red]$-#,# #0 ";//applying The style to A3 Cellworksheet. Cells["A3"]. SetStyle (style);//saving the Excel fileworkbook. Save ("c:\\book1.xls", saveformat.excel97to2003);

Aspose Number and date settings