Exporting to Web-page problem

GiMan

New Member
Joined
Jan 29, 2020
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
Hello to everyone, after weeks of unsuccessful attempts I kindly ask for an opinion.

It concerns exporting the print area of XXX.xls Sheet1 to web page (.htm); the xls sheet contains data and images (jpg, gif …. imported from the outside).

Well, with an old Excel 2003 (on Windows 10) there are no problems: the XXX.htm file and its XXX_file folder are correctly generated, limited to the print area as required, fully functional.

With Excel 2013 that’s not working. The file XXX.htm is created with the relative folder XXX_file containing the images, but when I open the .htm in the browser (Chrome, FireFox) the images are not there (everything else yes). Looking at the contents of the htm file, I note that there are no <img> tags as in the other one (2003), instead thousands and thousands of lines - similarly to what happens when the export is done to a “unique file web page” (.mht): but the extension of the generated file is correct (.htm), and the external folder “_file” is OK! (all images in there).

Excel 2013 is updated (it runs on Windows 7).

Tried with all possible combinations (without print area, all Sheets, etc.), but nothing changes. The .htm file can reach 70000 lines.

Tried to export to .mht format (unique web page): it works (but there are problems with this type of file with non-IE browsers).

Many many thanks for some suggestions.
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,093
Welcome to the Board



I tested this with Excel 2013, saving only one sheet with no print area defined. After publishing it, I opened it with CCleaner browser and the image was there, see below picture.

htm format.JPG
 

GiMan

New Member
Joined
Jan 29, 2020
Messages
2
Office Version
  1. 2013
Platform
  1. Windows
Thanks for your answer. I tested the files on Windows 10, and they work. So, there is something in Windows 7... i will upgrade it to 10
 

DaronX

New Member
Joined
Apr 29, 2020
Messages
4
Office Version
  1. 2019
Platform
  1. Windows
I have same problem. I drew a shape, saved it as a html and I can't see anything :(
 

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,093

ADVERTISEMENT

What Windows version are you using? I suppose it is Windows 10.
 

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,093

ADVERTISEMENT

See if you can visualize the shape on the HTM file I created:

zipped
 

DaronX

New Member
Joined
Apr 29, 2020
Messages
4
Office Version
  1. 2019
Platform
  1. Windows
I see the sun. Send me excel file. I will try to add shape.
 

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,093
Here is my test workbook. Note the protocol I used:

Save as / HTML / save sheet / publish / open in browser / publish.

source file
 

DaronX

New Member
Joined
Apr 29, 2020
Messages
4
Office Version
  1. 2019
Platform
  1. Windows
I opened your excel file / save as / web page / publish / open in browser / publish ......... and it opened blank page :(
 

Watch MrExcel Video

Forum statistics

Threads
1,122,454
Messages
5,596,228
Members
414,046
Latest member
mbeutler1203

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top