Click here to Skip to main content
15,897,718 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi,

I am new to xml and xslt. I am converting xml to excel using xslt, I am facing one issue while merging cells with having common data from a colom. I come to know that I can use ss:MergeDown attribute to cell to merge two or more cells but I dont know how to identify cells those are having same data. Please check below sample XML and expected result.

<?xml version="1.0"?>
<?xml-stylesheet type='text/xsl' href='\Transform.xslt'?>
<NewDataSet>
    <ReportSummary>
      <Division>US</Division>
      <Region>West</Region>
      <SalesTeam>abc abc</SalesTeam>
   </ReportSummary>
   <ReportSummary>
      <Division>US</Division>
      <Region>West</Region>
      <SalesTeam>abc saq</SalesTeam>
   </ReportSummary>
   <ReportSummary>
      <Division>US</Division>
      <Region>East</Region>
      <SalesTeam>abc xyz</SalesTeam>
   </ReportSummary>
   <ReportSummary>
      <Division>US</Division>
      <Region>East</Region>
      <SalesTeam>abc rte</SalesTeam>
   </ReportSummary>
   <ReportSummary>
      <Division>India</Division>
      <Region>West</Region>
      <SalesTeam>abc lmn</SalesTeam>
   </ReportSummary>
    <ReportSummary>
      <Division>India</Division>
      <Region>West</Region>
      <SalesTeam>abc str</SalesTeam>
   </ReportSummary>
</NewDataSet>


Expected XLS with merging of common cells in Division and Region coloms:


DivisionRegionSales Team
USWestABC
xyz
Eastasd
lmn
IndiaWesthgn
EastOLM



Please any help will be really appreciable.. Thanks in advance...
Posted
Updated 28-Oct-10 0:35am
v2
Comments
Sandeep Newad 14-Nov-10 23:19pm    
Is there any option of generating pivot table in excel by using xml and xslt ? I have successfully migrated a xml file to excel workbook with two sheets in it and I want to generated pivot table in first sheet and input will be second sheet. Please help me or suggest something in this regards. Any help or suggestion will be really helpful and appreciable.

1 solution

thanx but not useful..

give me specific link
if possible in php or any online converter.

urgent

thanks
Dinesh
 
Share this answer
 

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