Software

Ask something
Question Locked

how to convert html to excel using html code

0 helpful
5 replies

by kiko_xiatou 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

5 replies

by langlier

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

by angelwithmagicstick

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.. :)

by doug6388

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

This discussion is closed to new replies.