View Full Version : Heeeelllpppp!!
Medic193
6th August 2001, 11:37
I posted this in the software forum but didn't get any replies. When I save an excel document as a web page I can not get it to show any gifs or jpegs that I have placed in the table. It shows the pic but when I post it to the web it doesn't show up. The URL is correct. It's not just a mistake, I'm sure I just have to do something special when I create it that I don't know about. Does anyone know how to remedy this. It's for the total power page and I need to get it fixed. You can follow the link in my sig.
Martyn
6th August 2001, 12:14
what images are you trying to include? Where are they to go?
Medic193
6th August 2001, 12:17
If you look on the power page you will see at the top of the page. It's just our logo. If I save the page as an excel document it works fine, just when I save it as a web page it screws up. I've tried everything that I can think of to no avail.
Chris Wolfe
6th August 2001, 13:19
When you export from excel a couple of things happen. All included graphics are exported with the name "sheetfilename.graphicfileformat". For example, if the sheet is "totalpower.xls" and the graphic is "logo.gif", you will get a file called "totalpower_002.gif". The reason for the "_002" is the second part of what happens. Excel also exports the graphic as a bitmap which in our example would be called "totalpower_001.emz". It is set up in the html code to display "totalpower_001.emz" in IE browsers and maybe others. The way to fix this is to open the html in notepad and search for the .emz and .gif references.( in our example we had "logo.gif", if it were "logo.jpg", then we would search for .jpg). Change the references found in the html to the original filename that you imported into the excel spreadsheet. The reason for using the original filename is that any gif exported by excel loses any palette tranparency it had. Upload the sheet and the original graphic and you should be ok. If not, let me know.
Medic193
6th August 2001, 14:27
Thanks Chris. I read what you wrote there and it got me to thinking. You pointed me in the right direction. What I ended up doing was realizing that when you create the file with a pic it creates a new folder which it aims the src at. I uploaded that folder for it to point at and it worked like a charm. Thanks all!!
vBulletin® v3.7.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.