Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exporting html data to excel

 
vipul bondugula
Ranch Hand
Posts: 219
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Every one,

In the html page i am having table with three columns.Below the table, data will be displayed.Actually this is a report.

i am having an excel icon.when i click on this icon the data must be exported to excel sheet.

BedNo PatientName Remarks are the columns

I got the excel document.For this, i have put below code.
")

My requirement is , data in remarks column is improper in excel sheet.

It is stretched and not considering new lines...

Please any one reply to this thread...

Thanks & Regards,
vipul Kumar.





 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What Excel will do when importing HTML is anyone's guess. if you want precise control over the spreadsheet, generate proper Excel files using a library such as Apache POI.
 
vipul bondugula
Ranch Hand
Posts: 219
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank for your reply.
I cannot use Apache POI for my project. As of my project is of maintenance, No new jar files will be added.
Without adding any jar file , is there any solution for this.

Please guide me..
Thanks & Regards,
Vipul Kumar.
 
William Brogden
Author and all-around good cowpoke
Rancher
Posts: 13061
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Excel can read a CSV - comma separated values - formatted text file, each line gets turned into one row.

Bill
 
vipul bondugula
Ranch Hand
Posts: 219
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks for your reply,

Excel can read a CSV - comma separated values - formatted text file, each line gets turned into one row.


What is CSV? What does it mean?
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64830
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
vipul bondugula wrote:Thanks for your reply,

Excel can read a CSV - comma separated values - formatted text file, each line gets turned into one row.


What is CSV? What does it mean?


As already explained: comma separated values
 
vipul bondugula
Ranch Hand
Posts: 219
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry i don't mean that..

CSV means "is it any format or what".Actually what you are trying to say i am unable to get clearly.

Please explain clearly from where should i start?

Thanks & Regards,
Vipul Kumar.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64830
86
IntelliJ IDE Java jQuery Mac Mac OS X
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic