Converting HTML to Excel

Question

I know that Excel is capable of opening HTML files directly  But the content of the file will still be HTML  Is there any way I can change the contents of the file from HTML to XLS or XLSX

User · Answer

Change the content type to ms-excel in the html and browser shall open the html in the Excel as xls  If you want control over the transformation of HTML to excel use POI libraries to do so

User · Answer

So long as Excel can open the file  the functionality to change the format of the opened file is built in   To convert an  html file  open it using Excel  File - Open  and then save it as a  xlsx file from Excel  File - Save as    To do it using VBA  the code would look like this   Sub Open HTML Save XLSX        Workbooks Open Filename   C  Temp Example html      ActiveWorkbook SaveAs Filename              C  Temp Example xlsx   FileFormat             xlOpenXMLWorkbook  End Sub

User · Answer

We copy paste html pages from our ERP to Excel using  paste special   as html unicode  and it works quite well with tables

[html] Converting HTML to Excel?

Examples related to html

Examples related to excel-2007