Solved

Exporting jsp data to excel in .csv extension

Posted on 2004-08-17
4
358 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
  • 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Read about why website design really matters in today's demanding market.
Get to know the ins and outs of building a web-based ERP system for your enterprise. Development timeline, technology, and costs outlined.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will get a basic understanding of what section 508 compliance can entail, learn about skip navigation links, alt text, transcripts, and font size controls.

770 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