File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Writing to an excel sheet from java servlet

 
Sumit Arora
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 688
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic