Solved

Exporting jsp data to excel in .csv extension

Posted on 2004-08-17
4
368 Views
Last Modified: 2012-05-05
I am exporting the data from my portal to excel sheet using .csv format.The problem which i am facing is when the data is exported to client's machine it size becomes 6 times the actual size of data eg if the size of the actual data is 1 kb the size of the exported .csv file become 6 kb, because of this size problem i could not open the file in Excel becouse i have a huge data upto 16 mb to be exported
0
Comment
Question by:guddan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
avidya earned 50 total points
ID: 11826101
Excel as has limitation of importing 65536 rows of data, maybe you exieded it?
Also, when you import as csv as xls it will grow.
You could try just opening the csv.
0
 
LVL 10

Expert Comment

by:avidya
ID: 12115340
Hi,

Would you be so kind to respond to the suggestion?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Responsive Design or Mobile Sites? 4 36
Select only the top record in a left join 13 48
Code Manager | Snippits 2 59
asp web application 3 37
Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question