| Question ID: |
Q1011 |
| Question: |
Can SiteXpert export a list of links to Microsoft Excel, Word or a database? |
| Product: |
Sitexpert |
SiteXpert 6.0 is an open application and can import/export data from virtually any other application using XML/XSL. However, you will need the Professional Edition of SiteXpert to import/export XML documents.
The problem can be solved by either creating an XSLT style or by selecting "Generate / Export XML layout" from the toolbar.
This document uses the first approach. Go to Options / Style and select "Custom XSLT style". Now enter the following XSL transformation script into the script window:
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="html" version="4.0" omit-xml-declaration="yes"/>
<xsl:template match="/">
<html>
<table>
<tr>
<td>
<b>Link</b>
</td>
<td>
<b>Description</b>
</td>
</tr>
<xsl:apply-templates />
</table>
</html>
</xsl:template>
<xsl:template match="node">
<tr>
<td>
<a>
<xsl:attribute name="href">
<xsl:value-of select="@href"/>
</xsl:attribute>
<xsl:value-of select="@href"/>
</a>
</td><td>
<xsl:value-of select="text"/>
</td>
</tr>
<xsl:apply-templates select="node"/>
</xsl:template>
</xsl:stylesheet>
Now you can open the generated HTML file in Microsoft Excel or Word, which will insert data from HTML tables into cells.
This example demonstrates a simple XSL transformation that generates an HTML file with a single table whose cells are filled with link and description of documents. You can easily create another XSL transformation that will generate a tab-delimited text file, or any other text, HTML, or XML format. |
Save This Page