• Post Reply Bookmark Topic Watch Topic
  • New Topic

Number Stored as Text in Excel Output  RSS feed

 
anvi kon
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I'm using jxl for exporting data from java to excel.
when I export data on excel the number stored as text not numbers, so I can't do arithmetic on these fields.

What is the best way to stored as a number on excel?


thanks,






 
Rob Spoor
Sheriff
Posts: 21117
85
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How are you creating your cells?

Moving to Other Open Source Projects.
 
anvi kon
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm creating cells like below




Calling like below



thanks

 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Isn't there a way to set the cell type explicitly to numeric? Also, "Label" sounds more like string-type entity than a numeric entity.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!