Transforming dataset to spreasheet xml for excel

[Guest]

I tried ou
http://support.microsoft.com/default.aspx?scid=kb;en-us;319180&Product=as
I am using framework 1.1 but it was showing error for the following line in SendResults functio
xslTran.Transform(xmlDoc, Nothing, context.Response.OutputStream
So I changed it to xslTran.Transform(xmlDoc, Nothing, context.Response.OutputStream, Nothing
It is opening in excel but with a junk value.
What could be the problem
Any help is welcom
Regard
Satis

 

[Cor Ligthert]

Hi Satish,

Did you already tried what dataset.writeXML(path) does for you, that writes
direct a XML file from a Dataset.

Cor

 

[Guest]

Hi Cor
I did try that. But I need to format the excel sheet. For example, I would like write sheet name
So as the suggest example in the microsoft site , I am trying the same

Regard
Satish

 

[Cor Ligthert]

Hi Satish,

I do not know, however there are answers in the dotnet newsgroups, you can
check this I get the idea there is something for you there

http://tinyurl.com/2nvbg

I hope this helps?

Cor

 

[Guest]

Hi Cor

The url leads to http://support.microsoft.com/default.aspx?scid=KB;EN-US;31918
I am trying out using the same url. In the page it has been mentioned about XslTransform.Transfor
but I could not resolve my problem using the same.

Regard
Satish