xsl to convert xml to excel
Can someone please answer my question below I am stuck. On Thursday 04 March 2004 03:41 pm, Anna Bikkina wrote: > Hi, > > I have a xml file that has to converted to excel. I am trying to use a xsl > s stylesheet and cocoon to do this job for me. > > Below is my xml. I am able to display the column's correctly in excel but > when it comes to data . I am not able to have data in column1, > data in column. I am not able to increment the column value from 0 > to 5. The problem is the number of columns I will have is not known prior . > So I have to use the count() function to get this done. The way it is > printing row data right now is in column 5 it prints the value of > thats it. Please check the xsl below and let me know where I am making a > mistake. > > > > > > from="result" count="column"/> > > > > > > > > > > > from="result" count="row"/> > count="column"/> > > > > > > > > > > > mode="value"/> > > > > > > > > > My XML FILE > > > > > Hello > > > Time > Action > Price > User > User1 > >1 >12 >13 >12000 >12 > > > > > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: xsl to convert xml to excel
Nevermind,I got most of it working except that column0 is left blank and the whole data is printed from column1. Not sure where I am making a mistake. Can someone help. here is my latest xsl Thanks in advance, Anna. On Friday 05 March 2004 11:31 am, Anna Bikkina wrote: > Can someone please answer my question below I am stuck. > > On Thursday 04 March 2004 03:41 pm, Anna Bikkina wrote: > > Hi, > > > > I have a xml file that has to converted to excel. I am trying to use a > > xsl s stylesheet and cocoon to do this job for me. > > > > Below is my xml. I am able to display the column's correctly in excel but > > when it comes to data . I am not able to have data in column1, > > data in column. I am not able to increment the column value from > > 0 to 5. The problem is the number of columns I will have is not known > > prior . So I have to use the count() function to get this done. The way > > it is printing row data right now is in column 5 it prints the value of > > thats it. Please check the xsl below and let me know where I am > > making a mistake. > > > > > > > > > > > >> from="result" count="column"/> > > > > > > > > > > > > > > > > > > > > > > > from="result" count="row"/> > > > from="result" count="column"/> > > > > > > > > > > > > > > > > > > > > > > > mode="value"/> > > > > > > > > > > > > > > > > > > My XML FILE > > > > > > > > > > Hello > > > > > > Time > > Action > > Price > > User > > User1 > > > > 1 > > 12 > > 13 > > 12000 > > 12 > > > > > > > > > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: xsl to convert xml to excel
I think you need to replace the match in your last template: As it is now, it's going to catch a lot of calls that it shouldn't, and prevent the process from reaching some other templates. Also, I don't think this is doing what you want: It should just be . Peter Peter Binkley Digital Initiatives Technology Librarian Information Technology Services 4-30 Cameron Library University of Alberta Libraries Edmonton, Alberta Canada T6G 2J8 Phone: (780) 492-3743 Fax: (780) 492-9243 e-mail: [EMAIL PROTECTED] > -Original Message- > From: Anna Bikkina [mailto:[EMAIL PROTECTED] > Sent: Friday, March 05, 2004 01:28 PM > To: [EMAIL PROTECTED] > Subject: Re: xsl to convert xml to excel > > > > Nevermind,I got most of it working except that column0 is > left blank and the > whole data is printed from column1. Not sure where I am > making a mistake. > > Can someone help. > > here is my latest xsl > > > > > > name="colnumber"> from="column" count="column"/> > > > > >mode="value"/> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Thanks in advance, > Anna. > > > On Friday 05 March 2004 11:31 am, Anna Bikkina wrote: > > Can someone please answer my question below I am stuck. > > > > On Thursday 04 March 2004 03:41 pm, Anna Bikkina wrote: > > > Hi, > > > > > > I have a xml file that has to converted to excel. I am > trying to use > > > a xsl s stylesheet and cocoon to do this job for me. > > > > > > Below is my xml. I am able to display the column's correctly in > > > excel but when it comes to data . I am not able to have > data > > > in column1, data in column. I am not able to > increment the > > > column value from 0 to 5. The problem is the number of columns I > > > will have is not known prior . So I have to use the > count() function > > > to get this done. The way it is printing row data right now is in > > > column 5 it prints the value of thats it. Please > check the > > > xsl below and let me know where I am making a mistake. > > > > > > > > > > > > > > > > > > name="colnumber"> > > from="result" count="column"/> > > > > > > > > > > > > > > >mode="value"/> > > > > > > > > > > > > > > > > > > > > from="result" count="row"/> > > > > > from="result" count="column"/> > > > > > > > > > > > > > > > > > > > > > > > > select="$cnumber"/> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > My XML FILE > > > > > > > > > > > > > > > Hello > > > > > > > > > > Time > > > > Action > > > > Price > > > > User > > > > User1 > > > > > >1 > > > > 12 > > > > 13 > > > > 12000 > > > > 12 > > > > > > > > > > > > > > > > > > > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]