|
is it possible to insert an image into excel xml file generated by xslt. and i have 64 bit encoded string for an image how can i generate an image using xsl into excel xml file
can any body have an idea pls help me
Thanks in advance
raja
|
|
|
|
|
I have MS Excel 2003 and I cannot even save an image in a Xml Spreadsheet. As far as I know, in order to get that to work, you will have to write a macro (in Excel) that converts a 64-bit encoded string into a graphic, hide the string, and insert the graphic.
Geo
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
hi george,
thanks for your response,
pls help me i am new to xml and computer field can u please explain me where can i get the material for to do this
thanks
raja
|
|
|
|
|
In Excel 2003, the macro language is VBA. So, you will need to find code for Visual Basic that does a conversion from a 64-bit encoded string to the graphic format of your choice. Anyway, you will need to learn how to use VBA in Excel. I have never attempted to do such a thing. Thus, you need to do some Googling.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
thank you george.
if i have any problem 'll let you know
thanks
raja
|
|
|
|
|
Hello,
I am developing a VB .Net 2005 project.
I have a problem, i have a app.config file which I have entered connection strings and other setting from the project properties tab. This has automatically generated the app.config file for me.
I have edited the app.config myself and entered a new section which I did manually. However, now that I have done this the existing code in the app.config doesn't work.
Summary: If I add my own manually entered config sections with what has been automatically generated. But parts don't work.
If I just add my own manually entered and commit out the rest my own manually works fine.
It doesn't work with both. I was thinking of adding a new app.config file, which has the default name of app1.config.
But I am sure how I would reference each one when the program runs.
The config file is below, my manual section is the appUpdater, at the bottom.
Is there a way that I can include my own manual entered sections?
<code>
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
<section name="CodeRed.My.MySettings" type="System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />
</sectionGroup>
</configSections>
<connectionStrings>
<add name="CodeRed.My.MySettings.ServiceMasterConnectionString"
connectionString="Data Source=dev01;Initial Catalog=ServiceMaster;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.diagnostics>
<sources>
<!-- This section defines the logging configuration for My.Application.Log -->
<source name="DefaultSource" switchName="DefaultSwitch">
<listeners>
<add name="FileLog"/>
<!-- Uncomment the below section to write to the Application Event Log -->
<!--<add name="EventLog"/>-->
</listeners>
</source>
</sources>
<switches>
<add name="DefaultSwitch" value="Information" />
</switches>
<sharedListeners>
<add name="FileLog"
type="Microsoft.VisualBasic.Logging.FileLogTraceListener, Microsoft.VisualBasic, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL"
initializeData="FileLogWriter"/>
<!-- Uncomment the below section and replace APPLICATION_NAME with the name of your application to write to the Application Event Log -->
<!--<add name="EventLog" type="System.Diagnostics.EventLogTraceListener" initializeData="APPLICATION_NAME"/> -->
</sharedListeners>
</system.diagnostics>
<applicationSettings>
<CodeRed.Mail>
<setting name="MailSetting" serializeAs="String">
<value>MAPI</value>
</setting>
</CodeRed.Mail>
</applicationSettings>
<userSettings>
<CodeRed.My.MySettings>
<setting name="MailSetup" serializeAs="String">
<value />
</setting>
</CodeRed.My.MySettings>
</userSettings>
<!-- My manaul settings -->
<configSections>
<section name="appUpdater"
type="Microsoft.ApplicationBlocks.ApplicationUpdater.UpdaterSectionHandler,Microsoft.ApplicationBlocks.ApplicationUpdater" />
</configSections>
<appUpdater>
<UpdaterConfiguration>
<polling type="Seconds" value="120" />
<logListener logPath="G:\Reality Solutions Projects\CodeRed Application\CodeRed\UpdaterLog.txt" />
<downloader
type="Microsoft.ApplicationBlocks.ApplicationUpdater.Downloaders.BITSDownloader"
assembly="Microsoft.ApplicationBlocks.ApplicationUpdater,Version=1.0.0.0,Culture=neutral,PublicKeyToken=null"/>
<validator
type="Microsoft.ApplicationBlocks.ApplicationUpdater.Validators.RSAValidator"
assembly="Microsoft.ApplicationBlocks.ApplicationUpdater,Version=1.0.0.0,Culture=neutral,PublicKeyToken=null">
<key>
<RSAKeyValue>
<Modulus>4+xKqMoUfQDi+6ckQGHdPgW/QFPxR27VbRldQqAeftE1Xzbb5sOFdehaUF98oAisifDtn8D/UJ1WwK0wpOPLYtxyU2Nzsn6eOSJ12hnGVzgxq64F+Lz3tcMF4ji1RE8EWD8pn1yVGHjoowW2dKmlcumv1r7/vW7ZlhiEOrBL/AU=</Modulus>
<Exponent>AQAB</Exponent>
</RSAKeyValue>
</key>
</validator>
<application
name="CodeRed"
useValidation="true">
<client>
<baseDir>G:\Reality Solutions Projects\CodeRed Application\CodeRed</baseDir>
<xmlFile>G:\Reality Solutions Projects\CodeRed Application\CodeRed\AppStart.exe.config</xmlFile>
<tempDir>G:\Reality Solutions Projects\CodeRed Application\CodeRed\newFiles</tempDir>
</client>
<server>
<xmlFile>http://localhost/ServerNorthUpdater/Manifest.xml</xmlFile>
<xmlFileDest>G:\NorthUpdater\Manifest.xml</xmlFileDest>
<maxWaitXmlFile>60000</maxWaitXmlFile>
</server>
</application>
</UpdaterConfiguration>
</appUpdater>
</configuration>
</code>
|
|
|
|
|
|
When defining an XML Schema, is it possible to specify that an attribute is required when another is set to a certain value? For example, if the type attribute of my server element is set to DMZ, then the username and password attributes of the deploy element must be set as well.
Is this possible, or do I just have to enforce it in the code library that consumes the xml file?
Thanks.
Kyosa Jamie Nordmeyer - Taekwondo Yi (2nd) Dan
Portland, Oregon, USA
www.defaultn.com
|
|
|
|
|
Sorry, that is not possible.
"We make a living by what we get, we make a life by what we give." --Winston Churchill
|
|
|
|
|
Crap. That's what I was thinking, but I was hoping someone would tell me that I was wrong.  It'd be nice, though. 
Something like:
<xs:attribute name="UserName" use="Conditional" test="some/xpath/@value=dmz"/>
Kyosa Jamie Nordmeyer - Taekwondo Yi (2nd) Dan
Portland, Oregon, USA
www.defaultn.com
|
|
|
|
|
newbie12345678910 wrote: <url><http://www.companycasuals.com/altodairy/start.jsp</url>
Was the extra < at the start of the url intentional?
-- modified at 4:24 Sunday 17th June, 2007
|
|
|
|
|
I would appreciate if someone could explain what data I need to pass through to the SHA1 digest function to produce the same DigestValue as in the example below. When I pass the content of the ns1:Operation node I get a completely different DigestValue to that shown in the example! Do I need to add in any other data i.e. another ns value???
Here are the parts of the XML document of interest for this calculation, if you need further data let me know:
<ns1:Operation Id="MsgOperation" soapenv:mustUnderstand="0"
xsi:type="xsd:string" xmlns:ns1="http://www.ros.ie/schemas/service/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-
instance">CT1/File</ns1:Operation>
...
<ds:SignedInfo>
<ds:CanonicalizationMethod Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/>
<ds:SignatureMethod Algorithm="http://www.w3.org/2000/09/xmldsig#rsa-sha1"/>
<ds:Reference URI="#MsgOperation">
<ds:Transforms>
<ds:Transform Algorithm="http://www.w3.org/2001/10/xml-exc-c14n#"/>
</ds:Transforms>
<ds:DigestMethod Algorithm="http://www.w3.org/2000/09/xmldsig#sha1"/>
<ds:DigestValue>wJsL4RtLToFeHW/xt2ewbAAiNxk=</ds:DigestValue>
</ds:Reference>
|
|
|
|
|
I am using an xml file as a data source for site navigation on my asp website. All but one link points to files that are contained with in the project. Here is an example:
<section>
<id>customers</id>
<image>customers.jpg</image>
<name>Customers</name>
<url>customers/</url>
<subSection>
<id>retail</id>
<name>Retail Cheese Shop</name>
<url>customers/retail/</url>
<detailSection>
<id>logoitems</id>
<name>Alto Logo Items</name>
<url><http://www.companycasuals.com/altodairy/start.jsp</url>
</detailSection>
</subSection>
</section>
The urls all work with one exception. The last <detailsection> points to a website outside of the project.
When I run this I get an error message that says: Cannot use a leading .. to exit above the top directory.
Does anyone know what I would use to exit above the top directory?
John
|
|
|
|
|
I think your chance to get an answer is much higher in the ASP.NET forum as the scope of your question of course involves an XML file but it is nevertheless very ASP.NET specific.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
"\" this is coming in my Xml output.I want eliminate this.
I am writing code in C# using StringBuilder class and XMLTextWriter.
Any Properties or Method's are there to eliminate this.
|
|
|
|
|
saymajum wrote: I am writing code in C# using StringBuilder class and XMLTextWriter.
Show us the code, so we can tell you what you're doing wrong.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
i have a database object which retrieves all the data.
and i have the xml file(excel format) in textwriter mode. how can i attach dtaset to xml file and i want to transform that using xsl file
can any body know this pls help me
thanks
satya
|
|
|
|
|
Hi,
This is not a solution to your question, I have a similar problem where I need to export to Excel from a database. I am having no success. Please if you have a solution please can you let me know.
Regards
ma se
|
|
|
|
|
Hi
i am using c#.net
this is my code may be it is helpfull to u.
XmlDataDocument xdd= new XmlDataDocument(dataset object )
XslCompiledTransform xt=new XslCompliedTransform()
xt.load("~/.xsl");
XslArgumentlist xal=new XslArgumentlist();
xt.transform(xdd,xal,response.output);
if u r using c# this is helpfull to u and add response.contenttype,response.addheader
thanks
|
|
|
|
|
fireDiary = "<?xml version="1.0"?>"+"<AscendantOne>"+"<?ao-type diarysave?>"+
"<?ao-userid " + aouserid.InnerText+"?>"+"<Activity type="system" description="Activity">"+
"<VersionedId/>+<Id /><Effective>06/07/2007</Effective ><Expiration /><Created>06/07/2007</Created>"+
"<CreatedBy>"+aouserid.InnerText+"</CreatedBy>"+"<Modified /><StepId /><Category>Testing POC</Category>"+
"<Type>ForPOC</Type>+<Description>Testing diary for POC. This is being triggered from Custom override</Description>+<Entered></Entered>"+
"<EnteredBy>"+aouserid.InnerText+"</EnteredBy>+<Scheduled />+<UserId >{B6398B1E-43D3-4521-BFE3-235C2073AFF4}</UserId>"+
"<Open /><Completed /><Completion /><CurrentStatus>Open</CurrentStatus><StatusChange /><Comment /></Activity></AscendantOne>";
-- modified at 23:43 Friday 15th June, 2007
|
|
|
|
|
saymajum wrote: Is there anything wrong in this statement
There is definitely something wrong with the question. First, what should this statement do? Second, what is not being done what should be done i.e. what is going wrong? Third, are you sure the statement displays as it should be? Especially the first line looks pretty weird.
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
For starters, you didn't check 'ignore tags', so your message was not legible. Second, what do YOU think is wrong with it, and why ? And why do you think someone would trawl through all that code looking for an error ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Who knows... But I can tell you two things at first glance to consider:
1. This is a C# question, not an XML question.
..and..
2. System.Text.StringBuilder is your friend.
|
|
|
|
|
Ihave a COM method which has Input,Outout as XML,
It includes loading a string in to XMLDOM and processing on the nodes.
i have used memory leak article on CP to find the MemoryLeak http://www.codeproject.com/tools/leakfinder.asp[^]
from my observation and some reading on google, it seems that Release() and LoadXML are two methods which seems to have some memory leak, but i simply could not find the work arround, i have also gone through the "Delayed Clean up mechanism" but again without solution to my problem
big problem is as the output XML grows there is more wastage of memory, as this method is called arround ~4200 time a day the resultant is mess
If this is a repost kindly redirect(as of now i can see only one post in the XML section)er to question !
|
|
|
|
|
I hope its not a memory leak its catching...
Caching
Caching situations will usually show up as leaks in leakdiag because they are allocations that have not been freed. In some situations, it is possible to prevent false positives by disabling caching. Otherwise, it would require a code review to identify the allocations are actually being cached for later reuse. If the leaks are showing up in specific allocators, then tracking only that allocator will prevent caching from appearing to be a leak since LeakDiag will tracke the originating allocation call instead of the underlying heap or virtual alloc calls which might be cached by the component. The COM allocator is one example of an allocator that can be used to prevent false leaks due to caching.
Regards
Anil
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
