SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Can't view web page when converting Excel worksheet to HTML

(6 posts)
  • Started 1 year ago by molly666
  • Latest reply from GuiltySpark
  • Topic Viewed 750 times

molly666
Posts: 3

OK, I have a very simple Excel (MS Office 2010) file with 2 rows & columns of text. I perform a "Save as" web page and I can view the htm file perfectly fine on my local hard drive using both my IE 9.0 browser and Firefox. When I upload the corresponding .htm file, and the folder (named "filename_files") with the associated .xml and sheet001.htm files, to my ISP domain I can no longer view the file correctly and just get what looks to be incorrectly formatted html.

The file is Book1.xls. When converted, I've uploaded 'Book1.htm' and the 'Book1_files' folder and files underneath.

Any clues as to why I can view it correctly on my local hard drive in my browser but not when uploaded to my ISP server?

Posted 1 year ago
Top
 
GuiltySpark
Posts: 4024

Hi molly666 ,

Welcome to HTG ,

It is hard to define without seeing the two images (local and web), might be better off asking your hosting site for help they should be able to look over the setup and tell you where you went wrong.

Posted 1 year ago
Top
 
molly666
Posts: 3

Here's the link to the URL that doesn't work - or at least shows badly formatted html code:

http://abs-cards.net/Book1.htm

But note, that this is the exact file that MS Excel produces when I perform a "Save As web page" function. I've also uploaded the associated Book1_files folder and files underneath.

Here's what it looks like on my local hard drive: http://abs-cards.net/Book1.png

I've contacted my ISP and they're no help - they say it's a coding problem (duh) and won't help unless I pay their web design service. As I said, this is what MS Excel produces and should work on their server as it does on my local hard drive. Any help is appreciated!

Posted 1 year ago
Top
 
GuiltySpark
Posts: 4024

Unless someone else can chime in I will have to have a look tomorrow as I'm on my phone and can't do much at the moment.

One thing to check is what the page source looks like on the web format in your first link to see what html code is there particularly in the BODY tag.
To view it just right click and select View Page Source.

Posted 1 year ago
Top
 
molly666
Posts: 3

OK, I just tried something. I deleted everything after the FIRST </html> tag, uploaded the modified file, now called Book2.htm (and associated files), and it now seems to work. So here's the original, UNaltered Excel-to-HTML file:

http://abs-cards.net/Book1.htm

and the modified:

http://abs-cards.net/Book2.htm

Note that this is from the same .xlsx file, just using a different filename. So why does Excel produce a lot of extra HTML code that seems to mess things up?

Posted 1 year ago
Top
 
GuiltySpark
Posts: 4024

I couldn't answer that as I tend to design so I can see the code and design views together and have never used an office program to do it.

There is a member called Moreeg here who may see this, they are a wizz when it comes to MS Office.

Posted 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.