Solved

How to fix table rowspan through XSL

Posted on 2011-03-19
8
678 Views
Last Modified: 2013-11-18
All,

I have my input table format as below

***************** Start: Input table format ********************
<Table o_frame="topbot" xmlns:aid="http://ns.adobe.com/AdobeInDesign/4.0/" aid:table="table" aid:trows="3" aid:tcols="6">
<Cell o_morerows="1" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="2" aid:ccols="1">Region</Cell>
<Cell o_nameend="col5" o_namest="col2" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="4">Supply</Cell>
<Cell orgrownum="1" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">% Increase</Cell>
           
<Cell orgrownum="2" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">1967-69</Cell>
<Cell orgrownum="2" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">1977-79</Cell>
<Cell orgrownum="2" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">1987-89</Cell>
<Cell orgrownum="2" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">1997-99</Cell>
<Cell orgrownum="2" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">1978-90</Cell>
<Cell orgrownum="3" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">10%</Cell>
<Cell orgrownum="3" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">5%</Cell>
<Cell orgrownum="3" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">6%</Cell>
<Cell orgrownum="3" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">7%</Cell>
<Cell orgrownum="3" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">8%</Cell>
<Cell orgrownum="3" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1">18%</Cell>
</Table>
***************** End: Input table format ********************

and when I run using below XSL

********************* Start of XSL ****************************
<xsl:template match="Table">
 <xsl:element name="table:table-column">
  <xsl:attribute name="table:style-name">Table1.A</xsl:attribute>
            <xsl:choose>
                <xsl:when test="@aid:tcols &gt;0">
                    <xsl:attribute name="table:number-columns-repeated">
                        <xsl:value-of select="@aid:tcols"/>
                    </xsl:attribute>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:attribute name="table:number-columns-repeated">
                        <xsl:value-of select="@aid:tcols"/>
                    </xsl:attribute>
                </xsl:otherwise>
            </xsl:choose>
     </xsl:element>
     <xsl:apply-templates select="Cell[1]" mode="row">
        <xsl:with-param name="cols" select="xsd:integer(@aid:tcols)"/>
     </xsl:apply-templates>    
</xsl:template>
 
<xsl:template match="Cell" mode="row">
<xsl:param name="cols" as="xsd:integer"/>
<xsl:variable name="next" as="element(Cell)?" select="following-sibling::Cell[sum((current(), preceding-sibling::Cell[. &gt;&gt; current()], .)/@aid:ccols) gt $cols][1]"/>
 <xsl:element name="table:table-row">
     <xsl:apply-templates select="., following-sibling::Cell[not($next) or . &lt;&lt; $next]" mode="cell"/>    
 </xsl:element>    
 <xsl:apply-templates select="$next" mode="row">
  <xsl:with-param name="cols" select="$cols[1]"/>
 </xsl:apply-templates>
</xsl:template>
 
<xsl:template match="Cell" mode="cell">
<xsl:element name="table:table-cell">
 <xsl:if test="position()!=last()">
  <xsl:attribute name="table:style-name">Table1.A1</xsl:attribute>
 </xsl:if>    
    <xsl:if test="last()">
  <xsl:attribute name="table:style-name">Table1.B1</xsl:attribute>
 </xsl:if>  
    <xsl:if test="@aid:crows > 1">
        <xsl:attribute name="table:number-rows-spanned"><xsl:value-of select="@aid:crows"/></xsl:attribute>
    </xsl:if>
    <xsl:if test="@aid:ccols > 1">
        <xsl:attribute name="table:number-columns-spanned"><xsl:value-of select="@aid:ccols"/></xsl:attribute>
    </xsl:if>
 <xsl:element name="text:p">
  <xsl:attribute name="text:style-name">Body text</xsl:attribute>
  <xsl:if test="@aid:theader">
   <xsl:element name="text:span">
    <xsl:attribute name="text:style-name">bold</xsl:attribute>
    <xsl:apply-templates />
   </xsl:element>
  </xsl:if>  
  <xsl:if test="not(@aid:theader)">
   <xsl:apply-templates />
  </xsl:if>  
 </xsl:element>
</xsl:element>
</xsl:template>

******************** End of XSL ******************************

I get below output:

****** Start: Output after running XSL ***************
<table:table table:name="" table:style-name="Table1">
<table:table-column table:style-name="Table1.A" table:number-columns-repeated="6"/>
<table:table-row>
<table:table-cell table:style-name="Table1.B1" table:number-rows-spanned="2"><text:p text:style-name="Body text"><text:span text:style-name="bold">Region</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1" table:number-columns-spanned="4"><text:p text:style-name="Body text"><text:span text:style-name="bold">Supply</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">% Increase</text:span></text:p></table:table-cell>
</table:table-row>
<table:table-row>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1967-69</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1977-79</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1987-89</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1997-99</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1978-90</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1967-69</text:span></text:p></table:table-cell>
</table:table-row>
<table:table-row>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1977-79</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1987-89</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1997-99</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1978-90</text:span></text:p></table:table-cell>
</table:table-row>
</table:table>
****** End: Output after running XSL ***************

which is not correct due to rowspan since I am not sure where it goes wrong because rowspan is not working. Since this rowspan value need to evaluate from aid:crows from individual <Cell>. Can you pl let me know where your IT can help me how to fix this XSL.

The correct output is

<table:table table:name="" table:style-name="Table1">
<table:table-column table:style-name="Table1.A" table:number-columns-repeated="6"/>
<table:table-row>
<table:table-cell table:style-name="Table1.B1" table:number-rows-spanned="2"><text:p text:style-name="Body text"><text:span text:style-name="bold">Region</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1" table:number-columns-spanned="4"><text:p text:style-name="Body text"><text:span text:style-name="bold">Supply</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">% Increase</text:span></text:p></table:table-cell>
</table:table-row>
<table:table-row>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1967-69</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1977-79</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1987-89</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1997-99</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1978-90</text:span></text:p></table:table-cell>
</table:table-row>
<table:table-row>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1967-69</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1977-79</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1987-89</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1997-99</text:span></text:p></table:table-cell>
<table:table-cell table:style-name="Table1.B1"><text:p text:style-name="Body text"><text:span text:style-name="bold">1978-90</text:span></text:p></table:table-cell>
</table:table-row>
</table:table>

Thanks for your help,

Regards,
Sam
0
Comment
Question by:rshk2001
  • 4
  • 4
8 Comments
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 35175358
Hi Sam,

Your algorithm for getting the rows seems broken.

Safest way to work is using the @orgrownum. The problem is that the first two cells don't seem to have this attribute.
Is there a reason for that?
I could get it fixed by assuming that the attribute defaults to "1"
Is that a safe assumption?

I would definitely group using the @orgrownum as a row indicator
0
 

Author Comment

by:rshk2001
ID: 35175461
Hi Gertone,

Thanks for your answer back.
I  assume that when I have "o_morerows" or "namest" or "nameend", I presume that that entry belongs to same group. So, your assuption is right and you assume as you predicted.

Thanks,
Sam

0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 35175613
you seem to have merged 2 tablemodels
namest and nameend come from CALS (start column and end column) but you don't define teh names of the different columns
morerows means there is a rowspan
I have the impression that what you have is the result of an uncomplete earlier transform,
is that correct?
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

Author Comment

by:rshk2001
ID: 35177368
No it is not merged table model. Rather it is an InDesign table model that is converted from a CALS model. No this XSL is the complete transformation mode for table.

Thanks,
Sam
0
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 500 total points
ID: 35179249
mmh, so InDesign had some importing issues maybe,

anyway, this seems to work
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:aid="http://ns.adobe.com/AdobeInDesign/4.0/"
    xmlns:table="urn:yours:table"
    xmlns:text="urn:yours:text"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema"
    version="2.0">
    <xsl:output indent="yes"/>
    
    <xsl:template match="Table">
        <xsl:element name="table:table-column">
            <xsl:attribute name="table:style-name">Table1.A</xsl:attribute>
            <xsl:choose>
                <xsl:when test="@aid:tcols &gt;0">
                    <xsl:attribute name="table:number-columns-repeated">
                        <xsl:value-of select="@aid:tcols"/>
                    </xsl:attribute>
                </xsl:when>
                <xsl:otherwise>
                    <xsl:attribute name="table:number-columns-repeated">
                        <xsl:value-of select="@aid:tcols"/>
                    </xsl:attribute>
                </xsl:otherwise>
            </xsl:choose>
        </xsl:element>
        <xsl:for-each-group select="Cell" group-by="xsd:integer((@orgrownum, 1)[position() = 1])">
            <xsl:element name="table:table-row">
                <xsl:apply-templates select="current-group()"/>
            </xsl:element>    
        </xsl:for-each-group>    
    </xsl:template>
    
    <xsl:template match="Cell">
        <xsl:element name="table:table-cell">
            <xsl:if test="position()!=last()">
                <xsl:attribute name="table:style-name">Table1.A1</xsl:attribute>
            </xsl:if>    
            <xsl:if test="last()">
                <xsl:attribute name="table:style-name">Table1.B1</xsl:attribute>
            </xsl:if>  
            <xsl:if test="@aid:crows > 1">
                <xsl:attribute name="table:number-rows-spanned"><xsl:value-of select="@aid:crows"/></xsl:attribute>
            </xsl:if>
            <xsl:if test="@aid:ccols > 1">
                <xsl:attribute name="table:number-columns-spanned"><xsl:value-of select="@aid:ccols"/></xsl:attribute>
            </xsl:if>
            <xsl:element name="text:p">
                <xsl:attribute name="text:style-name">Body text</xsl:attribute>
                <xsl:if test="@aid:theader">
                    <xsl:element name="text:span">
                        <xsl:attribute name="text:style-name">bold</xsl:attribute>
                        <xsl:apply-templates />
                    </xsl:element>
                </xsl:if>  
                <xsl:if test="not(@aid:theader)">
                    <xsl:apply-templates />
                </xsl:if>  
            </xsl:element>
        </xsl:element>
    </xsl:template></xsl:stylesheet>

Open in new window

0
 

Author Comment

by:rshk2001
ID: 35180574
Thanks Gertone and it works. I need to see how this goes when orgrownum occurs in middle of table. As of now, this works.
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 35181077
welcome
0
 

Author Comment

by:rshk2001
ID: 35185999
Gertone:

Sorry by selecting @orgrownum is not working rather, if o_morerows is selected is working. But as I said before when this position changes then grouping is not working. Moreover, this o_morerows value is not always "1" sometimes it varies.

I just attach a new table where you can notice o_morerows:

<Table o_frame="topbot" xmlns:aid="http://ns.adobe.com/AdobeInDesign/4.0/" aid:table="table" aid:trows="16" aid:tcols="6">
<Cell o_morerows="1" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="2" aid:ccols="1" aid:ccolwidth="50.78221062992125">Receptor</Cell>
<Cell o_morerows="1" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="2" aid:ccols="1" aid:ccolwidth="83.60640748031511">Location</Cell>
<Cell o_morerows="1" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="2" aid:ccols="1" aid:ccolwidth="128.90840748031513">Main function</Cell>
<Cell o_morerows="1" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="2" aid:ccols="1" aid:ccolwidth="80.05676377952739">Signalling system</Cell>
<Cell o_nameend="col6" o_namest="col5" align="center" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="2">Significant drugs</Cell>
<Cell orgrownum="2" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">Agonists</Cell>
<Cell orgrownum="2" aid:pstyle="T_col_hd_TableHead" align="left" rowsep="1" aid:table="cell" aid:theader="" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">Antagonists</Cell>
<Cell orgrownum="3" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT
</Cell>
<Cell orgrownum="3" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS</Cell>
<Cell orgrownum="3" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Neuronal inhibition¿Behavioural effects: sleep, feeding, thermoregulation, anxiety</Cell>
<Cell o_morerows="5" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">G protein (G/G)¿ cAMP (may also modulate Ca channels)</Cell>
<Cell orgrownum="3" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">Buspirone (PA)¿
¿
</Cell>
<Cell orgrownum="3" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">Ergotamine (PA)</Cell>
<Cell orgrownum="4" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT
</Cell>
<Cell orgrownum="4" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS, vascular smooth muscle, many other sites</Cell>
<Cell orgrownum="4" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Presynaptic inhibition¿Behavioural effects¿Pulmonary vasoconstriction</Cell>
<Cell align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">
</Cell>
<Cell orgrownum="4" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">Ergotamine (PA)¿Triptans</Cell>
<Cell orgrownum="4" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">Methiothepin</Cell>
<Cell orgrownum="5" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT
</Cell>
<Cell orgrownum="5" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS, lymphocytes</Cell>
<Cell orgrownum="5" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">1</Cell>
<Cell align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">1</Cell>
<Cell orgrownum="5" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">1</Cell>
<Cell orgrownum="5" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">2</Cell>
<Cell orgrownum="6" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT
</Cell>
<Cell orgrownum="6" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS, blood vessels</Cell>
<Cell orgrownum="6" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Cerebral vasoconstriction¿Behavioural effects: locomotion</Cell>
<Cell align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">
</Cell>
<Cell orgrownum="6" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">
¿Triptans</Cell>
<Cell orgrownum="6" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">Ergotamine (PA)</Cell>
<Cell orgrownum="7" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT
</Cell>
<Cell orgrownum="7" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS</Cell>
<Cell orgrownum="7" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513"></Cell>
<Cell align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739"></Cell>
<Cell orgrownum="7" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125"></Cell>
<Cell orgrownum="7" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4"></Cell>
<Cell orgrownum="8" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT</Cell>
<Cell orgrownum="8" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS, uterus, heart, GI tract</Cell>
<Cell orgrownum="8" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">qw</Cell>
<Cell align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">RT</Cell>
<Cell orgrownum="8" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">Triptans?</Cell>
<Cell orgrownum="8" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">TY</Cell>
<Cell orgrownum="9" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT</Cell>
<Cell orgrownum="9" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS, PNS, smooth muscle, platelets</Cell>
<Cell orgrownum="9" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Neuronal excitation¿Behavioural effects¿Smooth muscle contraction (gut, bronchi, etc.)¿Platelet aggregation, Vasoconstriction/vasodilatation</Cell>
<Cell o_morerows="2" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">G protein (G/G)¿ IP, Ca</Cell>
<Cell orgrownum="9" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125"> (CNS)¿ (periphery)¿</Cell>
<Cell orgrownum="9" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">Cyproheptadine¿Pizotifen (NS)¿Methysergide</Cell>
<Cell orgrownum="10" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT</Cell>
<Cell orgrownum="10" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">Gastric fundus</Cell>
<Cell orgrownum="10" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Contraction</Cell>
<Cell align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">tt</Cell>
<Cell orgrownum="10" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">ss</Cell>
<Cell orgrownum="10" aid:pstyle="TableBody" align="left" rowsep="0" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">q</Cell>
<Cell orgrownum="11" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT</Cell>
<Cell orgrownum="11" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS, lymphocytes</Cell>
<Cell orgrownum="11" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">q</Cell>
<Cell align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">jk</Cell>
<Cell orgrownum="11" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">ER</Cell>
<Cell orgrownum="11" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">Methysergide</Cell>
<Cell orgrownum="12" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT</Cell>
<Cell orgrownum="12" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">PNS, CNS</Cell>
<Cell orgrownum="12" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Neuronal excitation (autonomic, nociceptive neurons)¿Emesis¿Behavioural effects: anxiety</Cell>
<Cell orgrownum="12" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">Ligand-gated cation channel</Cell>
<Cell orgrownum="12" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">TY</Cell>
<Cell orgrownum="12" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">Dolesatron¿Granisetron¿Ondansetron¿Palonosetron¿Tropisetron</Cell>
<Cell orgrownum="13" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT</Cell>
<Cell orgrownum="13" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">PNS (GI tract), CNS</Cell>
<Cell orgrownum="13" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Neuronal excitation ¿GI motility</Cell>
<Cell orgrownum="13" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">G protein (G)¿ cAMP</Cell>
<Cell orgrownum="13" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">Metoclopramide</Cell>
<Cell orgrownum="13" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4"></Cell>
<Cell orgrownum="14" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT</Cell>
<Cell orgrownum="14" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS</Cell>
<Cell orgrownum="14" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Modulation of exploratory behaviour (rodents)?</Cell>
<Cell orgrownum="14" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">As above</Cell>
<Cell orgrownum="14" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">gh</Cell>
<Cell orgrownum="14" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">er</Cell>
<Cell orgrownum="15" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT</Cell>
<Cell orgrownum="15" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS, leukocytes</Cell>
<Cell orgrownum="15" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Learning and memory?</Cell>
<Cell orgrownum="15" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">As above</Cell>
<Cell orgrownum="15" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">y</Cell>
<Cell orgrownum="15" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">q</Cell>
<Cell orgrownum="16" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="50.78221062992125">5-HT</Cell>
<Cell orgrownum="16" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="83.60640748031511">CNS, GI tract, blood vessels</Cell>
<Cell orgrownum="16" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="128.90840748031513">Thermoregulation? ¿Circadian rhythm?</Cell>
<Cell orgrownum="16" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="80.05676377952739">As above</Cell>
<Cell orgrownum="16" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="91.48221062992125">q</Cell>
<Cell orgrownum="16" aid:pstyle="TableBody" align="left" rowsep="1" aid:table="cell" aid:crows="1" aid:ccols="1" aid:ccolwidth="57.4">w</Cell>
</Table>


Thanks,
Raj
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question