Guest_imported
New member
- Jan 1, 1970
- 0
hi,
i'm trying to get the value stored in an excel file, let's say cell (2,4), and use it in my VB program (i would like to get the result in my processor.output). this is the XSL :
<xsl
aram name="excelFile"/>
<msxsl:script language="JScript" implements-prefix="xl">
var xlApp = new ActiveXObject("Excel.Application"
var xlWB = xlApp.Workbooks.open("C:/jay/perso/vbtests/example3/testExcel"
var xlWS = xlWB.ActiveSheet
function cell(row,col)
{
*** this returns the message 'the parameter is incorrect' :
return xlWS.Cells(2,4)
}
</msxsl:script>
<xsl:template match="/">
<NAC file="{$excelFile}">
<AccessHolder><xsl:copy-of select="xl:cell(2,4)"/></AccessHolder>
</NAC>
</xsl:template>
</xsl:transform>
thanx for your help.
i'm trying to get the value stored in an excel file, let's say cell (2,4), and use it in my VB program (i would like to get the result in my processor.output). this is the XSL :
<xsl
aram name="excelFile"/><msxsl:script language="JScript" implements-prefix="xl">
var xlApp = new ActiveXObject("Excel.Application"
var xlWB = xlApp.Workbooks.open("C:/jay/perso/vbtests/example3/testExcel"
var xlWS = xlWB.ActiveSheet
function cell(row,col)
{
*** this returns the message 'the parameter is incorrect' :
return xlWS.Cells(2,4)
}
</msxsl:script>
<xsl:template match="/">
<NAC file="{$excelFile}">
<AccessHolder><xsl:copy-of select="xl:cell(2,4)"/></AccessHolder>
</NAC>
</xsl:template>
</xsl:transform>
thanx for your help.