SiteXpert FAQ

Question ID:

Q1011

Question:

Can SiteXpert export a list of links to Microsoft Excel, Word or a database?

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.