• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

Exporting jsp data to excel in .csv extension

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
guddan
Asked:
guddan
  • 2
1 Solution
 
avidyaCommented:
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
 
avidyaCommented:
Hi,

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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now