Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error with HTML Excel

Status
Not open for further replies.

faeton13

Programmer
Mar 7, 2005
9
0
0
CO
Hi, I know that my problem might be way too specific and I don't know either if this is the correct place to post it, but I hope that somebody knows a way to solve my problem.
Here's what I'm trying to do:

I have a Table that has an image on the top, just a regular thing. Then I save the file as a web page. As it was expected, when I do that, the image is created in the web page folder as an independent file. When I edit the file with the notepad, you can see that the file is pointing at the new folder created to retrieve the image. What I need is to replace that link with a link on my own, let's say: "logo/image001.png". I did that and created the logo folder in the appropiate place. After that, if I open the file using Internet Explorer, there's no problem at all, but if I open the file using MS Excel, it prompts me with the following error:
"Some files in this page are not found in the specific location..."
If I say yes, It opens the file with the image, but also with a rectangle with the same size as the image, like when you get an unloaded image in a web page.

Whatever happens, I need to eliminate that error, What can I do???? Here's the part of the HTML code where I change the addres. I also changed the filelist.xml file to point at the logo folder, but even with that, nothing was solved.

<v:shapetype
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_s1029" type="#_x0000_t75" style='position:absolute;
margin-left:6pt;margin-top:0;width:459pt;height:105pt;z-index:1'>
<v:imagedata src="logo/image001.png"
o:title=""/>
<x:ClientData ObjectType="Pict">
<x:SizeWithCells/>
<x:CF>Bitmap</x:CF>
</x:ClientData>
</v:shape>><![endif]--><![if !vml]><span style='mso-ignore:vglayout;
position:absolute;z-index:1;margin-left:8px;margin-top:0px;width:612px;
height:140px'><img width=612 height=140
src="logo/image002.jpg" v:shapes="_x0000_s1029"></span><![endif]><span
style='mso-ignore:vglayout2'>
<table cellpadding=0 cellspacing=0>
<tr>
<td height=21 class=xl25 width=64 style='height:15.75pt;width:48pt'><a
name="Print_Area"></a></td>
</tr>
</table>
</span>
Does anyone know what I could do????? because I need the image to be in that other folder an no in the one that is created along with the html version of the excel table. The ultimate goal of this is to be able to send this excel file as a response message to client, from a wep application.

Thanks in advance.

Faeton 13
 
If it works in a browser but not Excel, than it is not an html issue. You should ask in the Excel forum (forum68).
 
I wrote a PHP application some years ago that ports html pages to excel. What you have up there is not a good starting point.

Excel actually has a very good html render ability (probably it uses IE). If you write good compliant HTML with full urls for images and serve up the page as xls instead of html you'll find the browser (FF and IE and Safari) all download the file and oen it up correctly... ecen though the document is actually HTML, Excel is smart ebnough to render out the HTML for you.

PHP
Code:
//Perform EXPORT

header("Content-type: application/x-msdownload");

header("Content-Disposition: attachment; filename=$estimateID$ReportName.xls");

header("Pragma: no-cache");

header("Expires: 0");

print "$header\n$ExportExcel";

die;

-Pete
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top