Question

Locked

how to convert html to excel using html code

By kiko_xiatou ·
may anyone tell me :how can I convert a html file to excel file? I mean how to extract the data from a html file into excel by using html code, but not directly rename the file extension to .xls. Like I only have to click on a button let's say 'convert' then the html file had to change into the excel file. can anyone tell me how to do this? Thank you very much.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Paste Special

by Langlier In reply to how to convert html to ex ...

Copy what you want from your HTML document. Then Paste Special into an excel document selecting HTML.

Collapse -

how can i copy and pate the html values to excel file

by ranjani_pec In reply to Paste Special

please give some idea or any simple code

Collapse -

Its pretty Easy

Just use

<%
response.setContentType("application/vnd.ms-excel");

%>

tag if you are using it in jsp page.
Let me know if u r still facing d prob.. :)

Collapse -

Try this for HTML - XLS reformat

by doug6388 In reply to how to convert html to ex ...

Move cursor from top left to bottom right of HTML web page data. When highlighted ( selected ) do Ctrl + C for copy.

Open xls spreadsheet to new worksheet and place cursor on A1 cell. Go to file > paste special and hit enter. When prompted, Check paste box plus move right to select AS: unicode text and then hit enter.

Worked for me

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums