SSDN - how can i insert an encoded image data in xslt

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

ks rs

Subject: how can i insert an encoded image data in xslt
Author: ks rs
Date: 21 Jun 2007 11:05 AM
Originally Posted: 20 Jun 2007 03:19 PM

Hi i have a xml file that is generated by dataset.
i created a xsl stylesheet and i used this stylesheet for transformation. when i transform the xml file using c#.net this xml file transforms and it open in a browser as a excel(xls) file using xsl file(i used styles,workbook properties in xsl file at the time of design).

now my problem is i have an encoded image data string for picture.
how to convert the
encoded Base64 data to be converted back as image using XSLT

if any body know the solution pls help me

Thanks And Regards
raja

(Deleted User)

Subject: how can i insert an encoded image data in xslt
Author: (Deleted User)
Date: 26 Jun 2007 06:09 AM

Hi raja,
a possible solution is to place the encoded base64 string inside a data: URL (see http://developer.mozilla.org/en/docs/The_data_URL_scheme for more details)

Hope this helps,
Alberto

ks rs

Subject: how can i insert an encoded image data in xslt
Author: ks rs
Date: 26 Jun 2007 01:45 PM

Hi alberto,
i write my code below. but i didn't find out the image in excel sheet can u pls help me

ss is name space of excel sheet which i mentioned in xslt

<ss:table>
<ss:Row ss:AutoFitHeight="0" ss:Height="15.25" ss:Index="4" ss:StyleID="BoldAndUnderline">
<ss:Cell ss:StyleID="s65" ss:Index="4">
<ss:Data ss:Type="String">
<img src="data:image/pjpeg;base64,%FF%D8%FF%E0%00%10JFIF%00%01%01%01%00H%00H%00%00%FF%DB%00C%00%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%01%"(part of image code) alt="abc"/>
</ss:Data>
</ss:Cell>
</ss:Row></ss:table>

(Deleted User)

Subject: how can i insert an encoded image data in xslt
Author: (Deleted User)
Date: 27 Jun 2007 03:42 PM

Hi raja,
the data that you placed in the URL is not base64; in any case, you may want to double check the official Microsoft schema for ExcelML to verify if/how images must be referenced (see
http://www.microsoft.com/downloads/details.aspx?familyid=FE118952-3547-420A-A412-00A2662442D9&displaylang=en)

Hope this helps,
Alberto

ks rs

Subject: how can i insert an encoded image data in xslt
Author: ks rs
Date: 28 Jun 2007 09:40 AM
Originally Posted: 28 Jun 2007 08:58 AM

Hi alberto,

i am sorry. i am mistaken i put some wrong code pls see below into my code.
i write my code below. but i didn't find out the image in excel sheet can u pls help me
can u pls help me where did i mistake
i didn't find the image in cell. and i mentioned the datatype as string is it correct . i have a doubt is this code correct for dispaly image in excel through xslt?
because all of my excel sheet generated perfectly..i used column width for table in a particular work sheet (totally 4 worksheets existed in my code)
if this code is wrong for inserting image into excel can u please send me an example how to insert image and i have no idea about vml namespace how to use this in xslt.
i am new to field pls excuse me and inform me pls

sorry for disturbing u . cna u please have a look into this

ss is name space of excel sheet which i mentioned in xslt

<ss:table>
<ss:Row ss:AutoFitHeight="0" ss:Height="15.25" ss:Index="4" ss:StyleID="BoldAndUnderline">
<ss:Cell ss:StyleID="s65" ss:Index="4">
<ss:Data ss:Type="String">
<img src="data:image/gif;base64,R0lGODlhTQAcAPcAAAAAjv%2BZAFJrvtHd%2FM7W7Yie4iAvif%2B7TW%2BEy45oSAAgnWl8xmVWXP%2FfpLO94gInof%2Fv08uodAAZnImW0mdoiUZguv%2FPfjRRshsthyhHr9GGF%2Ff8%2Fdzh8bzF5qa03gAPlufv%2BP%2BuKP%2FmuyA6qv%2BeEX2Qz1xxwa2Xihk3qPb5%2FQggnw4pmf%2FFY5Sl2Co6rJ6t3KZyLPejDvmnA%2F%2FZmQAIlM7e7wARme3v%2BEFTtsTM6BYvph4lovTy8TJMsd7l9Bkpo2Vwway23wAYpfetAHeKzf%2Fs0DBArCQ5ogAAmfL0%2BgcloQgpo%2Brx%2F7S%2F5EJbuP%2B4Q%2F%2Fdav%2BsFGN6xv%2BkCIWX0muByP%2F05OXp9v%2FleDFLshEwpqOv3dXU5MbR7Fhsv6%2B74ZSl3ihBrQATpYyc1NXd8Jun1iI%2FrL3N6AAAmSlKtf%2F%2F2FVlvCE1qP%2F%2FzP%2BpHkdYtoKT0A0hoP%2FgrBg6qv%2BpAFxyw9mOEv%2F47vT1%2BgAZq5JpRBIkof%2B3Lv%2B8UP%2FqxDdGrv%2F%2F%2FwMfpQUbmwcprQYTmf%2BlANjk8EpkvHOGy3uMzjpUtWF1xN7e97XF5nOEyTpKtRIoo0xUtzZDrdPY7snT7P%2B0ABYzq5yl3iw4qI2i2v%2FMZqNwNf%2FcnyQnqAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACH5BAQUAP8ALAAAAABNABwAAAj%2FAAEJHEiwoMGDCBMqXLiQE6cGECNCFGElIYEXQTJm5ACIgAcPGh3gMYjn4hgqKKmMCeJjA8IbZBx8%2FEimIIsQAXJO2bnTTR8%2FCBfZeEBUwZwOgBAsIUo0AwiCeDpIyaDAxoerV5dk2XLwyoIeWpSIVYJo5MA7fmY8IZGzbc4%2BB7uYsaGgLg0cVwB5kSChroIMKQaCSITCBl2%2FiGkgOohAwuG6EnrcOHhHRJ8YdOgU2swHgkEqfSE%2FaAFowyHEChYFBnTDBOrXNnR8MZiDzWO%2FI%2FIi5HFCw%2BbNUeQUTCLgsY0wNQ0pQg3HJSA4of0afsBXwocwlAzCURLdrxYHCgus%2F9gkIzMdCwUdaOlOZKQDM4iXcO2YobsCTG8WHPqDiYaRpwRd0cNtfikxwWoHUTKIGAmUR4cmBZXwmARa5CDQC%2Bt5N4lAoCGmRBXOCXSFFAgY5MEeBPpVh1kHgXCBGHkkkNkBdwxERg%2FR2XAIgCWoEJ0WACLwAWJhIKhQCocM%2BVpdikyGUBKIKCCEEHrQwUcRA3nAnV8SzAdIFQ8glkESAkmhZF1akMbQGT%2FQUJcNisyBmBkEKPRFXUIEAkMlDQiUghTRSYCcQHgIgJoXZlVxZl0G1qTQAtHR0MEhP3oQokFkLNFXHhjYgYVAlIRhHBXOkbEcYiWstoWPiElAwx9U%2BP%2BAkA8uuKnABygAEiVicBhZ0BUXRMcAFAKVoUB0SyAlUA5hdOflDUm%2BBsAHOFhqUAusKgDAAoBgGNoHi1xa0AYT8FWXARGowYQXj9HghZOABPFDoBYO1EUGH9inAA0qJGJkCpHQQBRfXBEwQmg2OAEgQjncRkEbA6BwJg1eAlJGHN3pNhAlTnxga2ISqClQEygSRUMWGwLSrF9m1IsQB%2Bv1ZcMRXARh7q1ZcDRQItkaBe9APiBixFVh%2BkWDC44CssDHNDji3BvIVmzQFRWYK4ElmUjxMQCJEJSCa1xWQOZBkziiAwBFHysBHAKRYYatsSn7nBLSTbDQGGcukQEKoUn%2FAIncgFDdKgK%2BFvSFER%2Fv64VAE3xM4SGLLLKAInTbtYC4BXWQOGoAeGHkJCu%2F2QLmhv%2FQ7hqAgIDD5tXdDJkTsibEwcFLKiDICwWx%2BdgHdbLWu0EEaCqdFIB4QIi%2BtSswgssHJbHI5nUBgMPCF0IS3Qext9CJCU0Y2UUWxqmAuwnQJ1%2FXbAq9AMCSNJSg3ZZ1mfFUClXQIIEOmEgigAAXzJuYEXjIgfC41DrX1eUDdlNIw15ztC6MawGtqsBkbiCAArYOMTZQQRmek7glQM4LIPRCHZxQuVstYmwvwxdqaAAEcV1BETlCwEh8QBXzqa0KKZhEfaQjAA7c4IdA9MEOo6KjCJ0hJAULWJ9fPrAHDxiEAy54DACCIJBJEGJRqDGMGcZAphZUpyoKwN1Botg65h0kCB94wBLW%2BIE3UG9ZbFDAGpfwgeykjgiHQMGtsHKVOTghEV1wyRUMNUcFZOF3BVmEEuZogzMs5AZfcIAkHRAEO%2F6qCZGUZBBYtIErdMADZQhlKF%2BQg5YMJAkdyCQlu1C4tjVhkh54I0NmScta2lIgAQEAOw%3D%3D"/>
</ss:Data>
</ss:Cell>
</ss:Row></ss:table>

i am looking forward for u.
thanks and regards
raja

(Deleted User)

Subject: how can i insert an encoded image data in xslt
Author: (Deleted User)
Date: 28 Jun 2007 10:02 AM

Hi Raja,
unfortunately it looks that your approach won't work, as Excel doesn't interpret the IMG tag as you would expect (see http://groups.google.com/group/microsoft.public.xml/browse_thread/thread/74bf87c04e09beca/8fbe9f9972aa8c59?lnk=gst&q=image+excel&rnum=1#8fbe9f9972aa8c59)

Alberto

ks rs

Subject: how can i insert an encoded image data in xslt
Author: ks rs
Date: 28 Jun 2007 11:17 AM
Originally Posted: 28 Jun 2007 11:18 AM

Thanks for your immediate response.

is there any way to insert image into excel through xslt?

Thanks and Regards
raja

ks rs

Subject: how can i insert an encoded image data in xslt
Author: ks rs
Date: 28 Jun 2007 11:30 AM

Thanks for your immediate response.

is there any way to insert image into excel through xslt?

Thanks and Regards
raja

(Deleted User)

Subject: how can i insert an encoded image data in xslt
Author: (Deleted User)
Date: 28 Jun 2007 11:53 AM

Hi Raja,
from what I can read in the link I provided, that's simply not possible; but after all I am only a support person for Stylus Studio, so I cannot state anything final about Microsoft Excel.

Alberto

ks rs

Subject: how can i insert an encoded image data in xslt
Author: ks rs
Date: 28 Jun 2007 01:49 PM

any how thanks for your reply alberto

thanks and regards
raja

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.