aspose file tools*
The moose likes Other Open Source Projects and the fly likes Excel file - download Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Excel file - download" Watch "Excel file - download" New topic
Author

Excel file - download

dwarakanathan thiru
Ranch Hand

Joined: Oct 14, 2009
Posts: 49
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.

Thanks,
Dwarak T
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41884
    
  63
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.


Ping & DNS - my free Android networking tools app
dwarakanathan thiru
Ranch Hand

Joined: Oct 14, 2009
Posts: 49
Hey Ulf,

So, how can this be fixed? Any other means other than letting the user do this work
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41884
    
  63
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Excel file - download