473,395 Members | 1,335 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Images in XML to be read INTO Excel

I'm looking to write XML and cannot figure out the syntax/format to designate a jpg image, which I know has to be pretty basic...the XML document I'm writing (programmatically) has some graphics along with some text and will be opened with Excel. I know there is a problem creating the XML from Excel containing images, so I am unable to look for the format/syntax to do this using that method...and hoping the reverse is not true --that importing of the images doesn't work either, as I cannot find information anywhere on this topic.
Any guidance is greatly appreciated.
Aug 23 '07 #1
2 10689
jkmyoung
2,057 Expert 2GB
I'm assuming you mean the proprietary Excel xml file format. Unfortunately, most image objects aren't stored inside the xml.

Would it be suitable to create a hyperlink to the jpg file instead?
eg
<Cell ss:StyleID="s21" ss:HRef="C:\My Pictures\aaaa.jpg"><Data
ss:Type="String">..\My Pictures\aaaa.jpg</Data></Cell>
Aug 23 '07 #2
Thank you for the reply!!! I am trying this as I write but receiving an error message...Ill keep trying to work through it. Unfortunately, the picture itself has to show as it is intended to be imbedded in the Page Header (a company logo) and must print. Going down this path, I didn't realize that the XML was proprietry (thank you MSFT!). I tried the format Word uses which has the unicode? of the image but that didn't work in Excel or I couldn't get it to work.
Aug 24 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: chrisse_2 | last post by:
Hi, All the records in my database will contain at least one picture. At the moment all the images are part of the database as ole objects although the database is way to big and there is only...
0
by: Pranav | last post by:
I've a web page that displays report data in a data grid an a chart ( I'm using Chart Fx for .Net which creates .PNG files on Server) I've a requirement to export the datagrid and chart both to...
0
by: jhgonzales | last post by:
The datagrid is exporting but without the images. When the file is downloaded, it seems that the excel file was supposed to have the images because they appear as "broken" image in the file. ...
2
by: Yaseen D M | last post by:
I have aspx page which contains some gif, jpg and png images. PNG image is generated dynamically. This file is basically a graph image. The problem i am facing in exporting these images to word,...
2
by: wstsoi | last post by:
hi I have to read images from spreadsheet, is it possible to do with php?
1
by: edwinparker | last post by:
Hi, I'm trying to convert a gridview to an excel report and have one small hang up. So far I've been able to create my gridview and export it to excel ok, but in my gridview I have an image. The...
0
blyxx86
by: blyxx86 | last post by:
I was having issues with exporting an ASP table that included images. I have since found a solution for this error, and hope that what I have found becomes useful for some others on this site. At...
6
by: Eddie | last post by:
Hi all, I am displaying a number of reports, and giving the users an option to display them on the web or download them to Excel. If they want the Excel file, I just use the PHP header command...
0
by: =?Utf-8?B?U2hhbQ==?= | last post by:
Hai all, In my application, I need to Export webpage things into hard drive. I am using gridview, and i export all things(with the help of some sites) into excel except images. Please, Can...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.