Member Avatar for shravanim
shravanim 0 Newbie Poster

Hi,
I have to generate an Excel sheet with specific format from an XML using XSLT.
I am having issue with defining Name Range, as i have requirement that all the rows in excel should be within a name range.I am writing following Tag for NameRange.
<Names>
<NamedRange ss:Name="Range1_Test" ss:RefersTo="=TestXSLT!R1C1:R4C4"/>
</Names>
But the problem is i don't know how many rows are going to be there, though i know number of columns.
is there any syntax which i can use so that all the filled rows in excel sheet come under that NameRange?
Thanks for your help!

  • 1 Contributor
  • 0 Replies
  • 51 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.