Forums Register Login

Problem with exporting data in excel

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
Which API are you using - jExcelApi? Apache POI?
+Pie Number of slices to send: Send
hi Tim, Actually i am not using any API. What am i doing i am converting my data to an html in string buffer and export buffer as excel.
i am implementing Apache POI. but mean while is there any way to do it in String buffer.
+Pie Number of slices to send: Send
Who knows what Excel does during HTML exports. If you want precise control over that, use an API that generates actual Excel files.
+Pie Number of slices to send: Send
yes Tim, i am implementing API for excel control.
Thanks for reply.
crispy bacon. crispy tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1083 times.
Similar Threads
Exporting Excel from jsp: response.setContentType();
Number Stored as Text in Excel Output
help me Xsl in struts2?
What should i use?
Alignment issue while Export data to Excel file from a jsp
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 19:13:13.