Dataexporter:Excel Cell type numeric

UI Components for JSF
Post Reply
webmailnet
Posts: 1
Joined: 28 Aug 2013, 10:41

28 Aug 2013, 10:47

How i can make a particular column as number instead of text

User avatar
sudheer
PrimeFaces Core Developer
Posts: 4345
Joined: 16 Oct 2011, 19:19
Location: Singapore

28 Aug 2013, 13:27

webmailnet wrote:How i can make a particular column as number instead of text
What do you mean? Each and Every cell written to the sheet in the format of String only.
Author,Speaker
https://twitter.com/sudheerjonna
Github: https://github.com/sudheerj
Website http://sudheerjonna.com/

___________________
Sudheer Jonna

kukeltje
Expert Member
Posts: 9605
Joined: 17 Jun 2010, 13:34
Location: Netherlands

28 Aug 2013, 15:30

sudheer wrote:
webmailnet wrote:How i can make a particular column as number instead of text
What do you mean? Each and Every cell written to the sheet in the format of String only.
Yes, and according to his question, that is not what he wants... What he means is obvious, that it can't be (easily?) done is also clear now. Maybe the exporter can try to convert a "string" to a number and if it succeeds write the celltype as a number.

User avatar
sudheer
PrimeFaces Core Developer
Posts: 4345
Joined: 16 Oct 2011, 19:19
Location: Singapore

28 Aug 2013, 15:42

kukeltje wrote:
sudheer wrote:
webmailnet wrote:How i can make a particular column as number instead of text
What do you mean? Each and Every cell written to the sheet in the format of String only.
Yes, and according to his question, that is not what he wants... What he means is obvious, that it can't be (easily?) done is also clear now. Maybe the exporter can try to convert a "string" to a number and if it succeeds write the celltype as a number.
That's fine.But I want to know why he want to make the cell type as number instead string.Any particular calculations or processing with excel sheet? Yes,He can customize the extensions exporter as he wish.
Author,Speaker
https://twitter.com/sudheerjonna
Github: https://github.com/sudheerj
Website http://sudheerjonna.com/

___________________
Sudheer Jonna

kukeltje
Expert Member
Posts: 9605
Joined: 17 Jun 2010, 13:34
Location: Netherlands

28 Aug 2013, 17:42

Any particular calculations or processing with excel sheet?
99.9% yes ;-)

danifuentes2000
Posts: 2
Joined: 18 Mar 2014, 12:39

29 Jan 2015, 12:05

Any solution for this problem?

Post Reply

Return to “PrimeFaces”

  • Information
  • Who is online

    Users browsing this forum: No registered users and 41 guests