Need help for converting XML data in excel spreadsheet and to show in web page...
-
Hi frnds... I hv excel template with it look and feel... Dat excel i hv converted into .xml file by saving excel sheet to xml. Used <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> and closing tag Nw i want to add data frm database into xml for which i hv used <xsl:for-each select="dataset/table"> and also use <xsl:if test="group_id=1"> then fill the first row of xml and for other group_ids... the xml file get generated bt when i open the xml file into excel file it gives me error XML ERROR in Worksheet Setting REASON: Bad Value FILE: C:\Documents and Settings\Administrator\Desktop\ReportsinExcelWithXML\AuthorReportGenerator\bin\DebugReport.xml GROUP: Worksheet TAG: Table ATTRIB: ExpandedRowCount VALUE: 58 and the <Table> tag of xml has <Table ss:ExpandedColumnCount="9" ss:ExpandedRowCount="58" x:FullColumns="1" x:FullRows="1" ss:StyleID="s25" ss:DefaultRowHeight="12"> plz help me... its urgent :(