permaculture playing cards*
The moose likes I/O and Streams and the fly likes Writing to an excel sheet from java servlet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » I/O and Streams
Bookmark "Writing to an excel sheet from java servlet" Watch "Writing to an excel sheet from java servlet" New topic
Author

Writing to an excel sheet from java servlet

Sumit Arora
Greenhorn

Joined: Dec 14, 2003
Posts: 1
Hi ,
I am trying to write to excel from a servlet.The data consists of timesheet data for the employees of the company.
The fields are Phase, Subphase,Date and Time spent. Right now I am throwing them in this format rowwise records.
eg

Phase Subphase Date Time
Planning Documentaion 15/10/2003 3.5
But the requirement in the template is for ths phase and subphase to be rowwise and the date to be increasing column wise and time to be filled in that.
eg
Phase Subphase 15/10/2003 16/10/2003 17/10/2003 18/10/2003
Planning Documentaion 3.5 4.5 5.5 2.0

Can someone help me in arranging in this format?
Adrian Yan
Ranch Hand

Joined: Oct 02, 2000
Posts: 688
I'm not quite sure what you asking for. Are you having problem writing to excel, or having problem with the formatting?
If you want to write to Excel in Java, you need the POI interface from Jarkata:
POI
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Writing to an excel sheet from java servlet
 
Similar Threads
Using JDBC to insert into MS Excel file
Excel-format report
what is this symbol "[$-409]dd-mmm-yy;@ " Excel to Java???
need of Design Pattern with servlet
String to DATE