Subject: Re: [xsl] Thank you all! (XML to Excel using XSLT)|
From: "Karen Yang" <kyang94@xxxxxxxxx>
Date: Fri, 23 Jun 2006 12:04:32 -0400
Great idea! (does this mean I'm too dumb? hehe... just kidding) Thank you. I'll try it out.
Perhaps this avenue is already obvious to you, but if you want to know how to format something in xml that Excel will use, then you can use Excel to show you:
1 Import your xml into Excel.
2 Add the sums and formatting you want in the final report.
3 Save as XML from Excel.
4 Look at the output - it will tell you the formatting instructions.
-----Original Message----- From: Karen Yang [mailto:kyang94@xxxxxxxxx] Sent: Friday, June 23, 2006 9:44 AM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: [xsl] Thank you all! (XML to Excel using XSLT)
Yeah!!! I just get my XSLT working, all the data showed up as I expected, and more important, I know the processing rule behind it. So if I get a new requirement, I would know where to start.
I'm just writing to THANK YOU all for all your great help! As a newbie, I felt so frustrated as I was the only one in our group is working on it, and now I feel so good since you guys are with me helping me out! So a big THANK YOU to all of you, a bigger one to the list managers and advocaters!
Now I'm working on the formatting issues, i.e. adding an empty line, and also some calculations, i.e. a summary for the column E (one node in XML). So I'm looking online for a good start now. If any of you have worked on that and have some light to shed, I'd greatly appreciate it.
Thanks & enjoy your day!