hi friends,
i have a problem with exporting data in excel by setting content - type Application/vnd.ms-excel.
The problem is when i export number
e.g 112233445566 it auto formatted to 1.12233E+11 (if number of digit is greater than 10) (no doubt by clicking on number actual number appears).
one solution i found is to send number as a text. but problem is the data is not editable after that.
i know i have to format size of the data cell from its default value. but the problem is how, using java code in servlet. or is there any another way.
Thanks in Advance.
i have a problem with exporting data in excel by setting content - type Application/vnd.ms-excel.
The problem is when i export number
e.g 112233445566 it auto formatted to 1.12233E+11 (if number of digit is greater than 10) (no doubt by clicking on number actual number appears).
one solution i found is to send number as a text. but problem is the data is not editable after that.
i know i have to format size of the data cell from its default value. but the problem is how, using java code in servlet. or is there any another way.
Thanks in Advance.