Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Excel file - download

 
dwarakanathan thiru
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I download some contents as an excel file using a servlet:


Now, the download excel sheet is not formatted properly. The columns do not get expanded to view the data.
Any reason why this happens? Or can we fix this column expansion via code?

This is a look and feel issue that I need to solve.

I appreciate any responses.
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This code just streams an existing file. What you describe is a formatting issue inside the file - that's where it needs to get fixed. Servlets have nothing to do with it.
 
dwarakanathan thiru
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hey Ulf,

So, how can this be fixed? Any other means other than letting the user do this work
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use one of the well-established XLS APIs (JExcelApi and Apache POI) to alter the file in any way you see fit before streaming it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic