File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes Exporting html data to excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Exporting html data to excel" Watch "Exporting html data to excel" New topic
Author

Exporting html data to excel

vipul bondugula
Ranch Hand

Joined: Oct 14, 2010
Posts: 218
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.






Thanks
Vipul Kumar
Ulf Dittmer
Marshal

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


Ping & DNS - my free Android networking tools app
vipul bondugula
Ranch Hand

Joined: Oct 14, 2010
Posts: 218
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

Joined: Mar 22, 2000
Posts: 12806
    
    5
Excel can read a CSV - comma separated values - formatted text file, each line gets turned into one row.

Bill
vipul bondugula
Ranch Hand

Joined: Oct 14, 2010
Posts: 218
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

Joined: Jan 10, 2002
Posts: 61437
    
  67

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


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
vipul bondugula
Ranch Hand

Joined: Oct 14, 2010
Posts: 218
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

Joined: Jan 10, 2002
Posts: 61437
    
  67

Comma-separated values
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Exporting html data to excel