Export C# Datagrid to Excel (XML has data but appears blank in Excel)



I am exporting data via C# to Excel using XML approach. I have a working XSLT created. The values are retrieved successfully from a stored procedure.


For one of the tables, some of the values are blank in Excel. I managed to display some of the values (one need to use CAST in the Stored Proc) but it appears blank for the others. I've checked the XML file and verified the structure. The structure is correct and the values are there. The XSLT is correct too.


I am using a xsl:for each to loop through the data and populate it in Excel. I still can't find the solution for the other fields after trying.


May I know whether I missed anything or need to check anything else?


No comments:

Post a Comment