XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
ks rsSubject: 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

Postnext
Alberto MassariSubject: how can i insert an encoded image data in xslt
Author: Alberto Massari
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

Postnext
ks rsSubject: 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>

Postnext
Alberto MassariSubject: how can i insert an encoded image data in xslt
Author: Alberto Massari
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

Postnext
ks rsSubject: 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

Postnext
Alberto MassariSubject: how can i insert an encoded image data in xslt
Author: Alberto Massari
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

Postnext
ks rsSubject: 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

Postnext
ks rsSubject: 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

Postnext
Alberto MassariSubject: how can i insert an encoded image data in xslt
Author: Alberto Massari
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

Posttop
ks rsSubject: 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 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.