How can I use XSLT and XML to compose Excel , which has dynamic fields?
Posted on 2007-04-10
My XML file has few static and few dynamic elements, like name is static, grap points is dynamic means its computed by average of "input" ( This I would do it from my application).
<name>Manjesh</name> // Static
<profession>Eng</profession> // Static
<gradpoints>12</gradpoints> // Dynamic field calculated by computing the average of input
<input>10</input> // Static
<input>12</input> // Static
<input>14</input> // Static
Name Profession GradPoints
Manjesh Engg 12
Once its done I would like to show only few relavent fields in my excel as mentioned above. Unfortunatley I dont have enough time to experiment XSLT and mapping to Excel. So if any expert can give the XSLT and steps for importing the same to excel .
Thanks for your earliest attention.