Click here to Skip to main content
15,747,637 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Friends

i have a function where i generate XLS using xslt transformation , the complete secanrio is as follows

i am using single XLST Template for different dataset's and generating xls file from it

since i cannot create different xslt template for each dataset or report, i am using template and using below function to populate the value ,

<xsl:value-of select="." />

the problem is when the dataset column has null value the column in xml is skipped and spoil the entire xlst transformation as the rows are pushed wrongly

is there a way to check if the current column is null and replace it with 0 or hypen "-" ,
in the below code itself without actually specifying the column name
<xsl:value-of select="." />

since my dataset and column are dynamic i cannot specifiy the column in xls if condition , you guys help will be really appreciated

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900