• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Tim Cooke
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Rob Spoor
  • Bear Bibeault
Saloon Keepers:
  • Jesse Silverman
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • Al Hobbs
  • salvin francis

How to create number Format with jexcel api - decimal separator

 
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hello,
i would like to create a number format wich give me an easy way to read my cells, as i have large number i would like to apply a new format on my numbers, like the example below :

76213879519 --- >76 213 879 519

or

76213879519 --- >76.213.879.519

many thanks

 
Bartender
Posts: 3648
16
Android Mac OS X Firefox Browser Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Did you check out the Jexcel API? There's a jxl.write.NumberFormats class
 
Ranch Hand
Posts: 32
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
With questions like these, I always suggest starting with Excel itself. Try to create a custom (hint) format for the cell that will do what you require. There is likely to be an example that you can edit; it will show the various placeholder characters that determine where the numeric characters and the separators will be placed. This formatting string will most likely be very similar to the one you pass to JExcels NumberFormat class.
 
reply
    Bookmark Topic Watch Topic
  • New Topic